ODBC runs slow

[Simon]

I currentlty use ODBC with accesss, i am new to using ODBC. Some times

i find that access runs much slower using ODBC than storing tables on
the computer.

Could you tell me of any way in which i could spped up ODBC and how to
design access and the tables to make them run a bit faster


Reply »

 

[Bill Mosca, MS Access MVP]

Many developers think a more powerful back end like SQL Server or Oracle
will make for a faster Access application. In reality, it will probably
suffer a bit in performance.

While you did not say you were using SQL Server as your back end, this
article might be of use:
http://msdn2.microsoft.com/en-us/library/bb188204.aspx

--
Bill Mosca, MS Access MVP


I currentlty use ODBC with accesss, i am new to using ODBC. Some times

i find that access runs much slower using ODBC than storing tables on
the computer.

Could you tell me of any way in which i could spped up ODBC and how to
design access and the tables to make them run a bit faster


Reply »

 

[Simon]

I am currenly use mySQL server with my hosting comapny

 

[Albert D. Kallal]

I am currenly use mySQL server with my hosting comapny

Ok, so that means you are connecting OVER the internet. That means your
connection speed is about 100 times slower then your cheap-o office network.
A high speed t1 internet line is 100 times slower then that cheap office
network...

So, why is 100 times slower slower?

Because 100 times less is a rather large number in terms of performance.....

You can read about using ms-access on a wan here:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html