Split Database too slow

[Jason Keys]

Hi,

I used the database splitter today, but it has made using the database unbearably slow - a form that was already slow to open (4-5 seconds) takes more like 30 seconds on the machines that will be using the DB. So, I changed it back. Will the problem here be the cross-tab queries, lookups or something else entirely?

Also I tried the original db (unsplit) on two adjacent machines - one with Access 2003, and the other with Access 2002. There was a huge difference in time to open forms - with the Access 2002 machine (which on specs is the better machine). The DB is created in 2003. This is probably a stupid question, but would you expect such a difference?

[Tanis]

I have not split my DB's, but know speed is an issue.
Could be your problem is the amount of network traffic you incurr.
Everytime it needs to go get some data, network traffic increases.
The more data it needs, the longer it takes n a slow line. The other problem is all the work is done in the FE in Access. if you changed it to use SQL, you could have the BE do some of the work and cut down on network traffic with proper design. Another problem is lookups.They are slow at the best of times. Here are a couple of links that might help.

http://allenbrowne.com/ser-01.html
http://www.granite.ab.ca/access/performancefaq.htm