stordaz Posted August 4, 2003 Posted August 4, 2003 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 it's 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. Quote
Administrators PlausiblyDamp Posted August 4, 2003 Administrators Posted August 4, 2003 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... Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
stordaz Posted August 4, 2003 Author Posted August 4, 2003 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. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.