Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Time out

Status
Not open for further replies.

funkytunaa

Technical User
Oct 9, 2005
116
AU
I have a problem. I have a fairly sizeable database, in that it's got quite a few million records. I found a few weeks ago it started timing out on some computers. Each computer has an access front end that does an "open form" and depending on the postcode that the user enters, it returns that postcode via a link criteria.

I suspect this is where it's bottoming out, I have tracked down in the Performance on the server the "Avg. Disk Queue Length" shoots up to 100 every once in a while and I think this is when the users open the form. It trundles along nicely and then all of a sudden, wham! it tops out again and people start getting timeout errors and each computers database grinds to a halt?

Ideas are MOST welcome, it may not be the best way toretrieve the data and I am open to suggestions.
 
If you are using an ADO command object, try setting .CommandTimeout = 0. Otherwise, please show us some code...

Beir bua agus beannacht!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top