Timer event causing db slowdown?

D

Doug Steele

I have a split database, with a front end (code, queries etc.) and back end (tables only). Computer A has a copy of both databases, Computers B,C and D have only the front end. Computer A's main menu has an optional timer event which runs every 60 seconds and performs a couple of queries. The queries take less than a second to execute. Whenever the timer event is turned on, it takes the other computers several seconds to open any other screen from the main menu screen (it should take <1 second). When editing, an hourglass appears intermittently and the keyboard locks up for up to 30 seconds. This behavior doesn't occur on computer A. As soon as the timer event on computer A is deactivated, the other computers start behaving normally.

I had a look at the CPU and network usage on computer A and they are minimal.

This is occurring using Office 2003 and Windows XP Pro.

Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Timer event causing db slowdown? 1
Understanding Timer Pause code 4
Understanding Timer Pause Code 6
Stuck on Office 2003 Menus, Task Bars, etc. 1
Upgrade 2000 to 2007 Now Cmd button on-click events don't trigger 2
Form Timer 2
Timer gettin complicated! 4
hh:mm:ss on a timer 2

Top