SQL and LAN: problems

stordaz

stordaz

Member
Joined
Apr 15, 2003
Messages
16
Location
Italy
Hi,

after changing all DAO access to my Access database in
SQL I found out that accessing database by SQL through a
LAN is terribly slow.
I mean, the same operation seems to be many many times slower!
(20 seconds in local compared to 5 minutes performed in LAN, and
its not LAN fault).

How is it possible?
Do you have and idea about solving these problem?
Is there someone else out there the same situation?

Thanks in advance.
 
A lot of things can affect performance in a Client / Server database.
You will probably need to check how the database is Indexed for starters.

Also a lot of your code may be doing things in an inefficient way (are you doing SELECT * anywhere, are you using lots of MoveNext commands on a recordset? etc)

Post some examples of the slow performing code if at all possible...
 
Thanks PlausiblyDamp,

I started trying to reduce the number of connection.open and
it seems things are going better...
I used to open the connection to db and immediately close it after
accessing so I have many of them; reducing them the
performance are considerably better.
 
Back
Top