468,301 Members | 1,402 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,301 developers. It's quick & easy.

Split Database too slow

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?
Oct 5 '06 #1
1 3415
Tanis
143 100+
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
Oct 5 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Tardus Merula | last post: by
3 posts views Thread by Venkat | last post: by
1 post views Thread by Query Builder | last post: by
12 posts views Thread by grace | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.