funkytunaa
Technical User
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.
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.