Server Creep (v2K)

Topic

New Reply

I created a database on our LAN with the front-end and back-end in one file while I developed it. It functioned fine and the response time was excellent. Upon completion, I copied the database, deleted all the tables from the original and linked the tables from the copy to the interface in the original. These are the normal steps I use to create a front-end/back-end database.
The problem is the response time. A drop-down that responded instantly now takes 7 seconds to show the values. Everything is ridiculously slow using the front-end/back-end. There are less than 1,000 records and the size of the database is small. As mentioned, it runs great as a single file. Usually the response time isn’t hindered when a database is split so this is why I’m puzzled.
Any help would be appreciated.

Reply | Quote

Replies

How does it run if you move both the front and back end to the local machine? How does it run with the front end on a local machine and the back end on the server? Did you remember to turn off subdatasheets and Name AutoCorrect? Those two items sap performance, especially with linked tables.

Reply | Quote

A local front-end/back-end setup works fine. A LAN b/e – local f/e is still painfully slow.
Autocorrect is off and the subdatasheet is on. I’ll turn the subdatsheet off tomorrow and will test performance. I also picked-up additional advice from posts you, Mark and Wendell made earlier this year to a similar question.
Thanks!

Reply | Quote

You’ll need to turn off subdatasheets for *each* table. I found the subdatasheets to be the biggest culprit in very slow loads, but one way to test it is to simply try to open the linked table from the front end database window. If opening the table like that is slow, then subdatasheets may very well be the problem.

Reply | Quote

Charlotte,
Thanks so much. I can’t believe the subdatasheets had that much of an impact. I removed the subdatasheets and loaded a few tables used for drop-downs on the front-end since they are static. Everything is running fine now.
Thanks and have a great day!

Reply | Quote

Amazing, isn’t it? I’ve never figured out what they were thinking when they designed subdatasheets and then made them always on by default!

Reply | Quote