By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,313 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

Split Database too slow

P: 4
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
Share this Question
Share on Google+
1 Reply


100+
P: 143
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.