why so slow when using access database over LAN?

[Bill White]

I am using access database as a db server over LAN in my program. I tested
it on my lan(xp, 2000 with 'FAT32' file system), it is running ok and the
speed is fast. but I don't know why it becomes so slow while running it on
another two pcs, both with xp system and 'NTFS' file system.

The program accesss database frequently, and database connection is always
opened before accessing db and then closed after finished it. Whether is it
the main reason that slow down the program on NTFS system? and why?

Thanks in advance.


Bill White

 

[Albert D.Kallal]

Well, you don't mention the speed of you LAN. Often a LAN is a good 10 times
slower then a hard disk.

So, that 3 seconds becomes 30+ seconds.

However, before you dismay, try using the persistent connection trick. That
means you open a table to a reocrdset and KEEP it open.

If this does not restore performance to that of on your local machine, then
either you got a slow network, or your application design is suspect.

The persistent connection trick has often speed up my applications by 50 to
100 times....

In addition, check your way through the following list of "go ya" (the
persistent connection trick is mentioned - so, in your startup code, open up
a table).

http://www.granite.ab.ca/access/performancefaq.htm

If you go thought the above list...and it sill don't fix things, then likely
this is a application (desing) problem.

Further, perhaps your database isn't split, and thus some other issues are
coming to play (is your application split? Did your turn off track name auto
correct?. Does your code compile...and are you placing a mde file on each
computer? (mde...not mdb)

If you database is not split, then read the following:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

If you database is split, and the data transfer is slow, then perhaps it is
your network. You can read the following about suing ms-access on a slow
network:

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

 

[Guest]

Hi Bill,

Here are some KB articles that you might find helpful:

http://support.microsoft.com/?id=814112

http://support.microsoft.com/?id=889588

Both of these are included in a new page that I just recently published:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________


:

I am using access database as a db server over LAN in my program. I tested
it on my lan(xp, 2000 with 'FAT32' file system), it is running ok and the
speed is fast. but I don't know why it becomes so slow while running it on
another two pcs, both with xp system and 'NTFS' file system.

The program accesss database frequently, and database connection is always
opened before accessing db and then closed after finished it. Whether is it
the main reason that slow down the program on NTFS system? and why?

Thanks in advance.


Bill White