Hi,
I have a front end/back end database with about 5 active users, usually no more than 2 are in the file at one time. for single row transactions there are no issues, however, for some of the larger reports/queries, if ONE extra person is in the file, it causes HUGE latency issues.
One report that normally takes about 10 minutes to run was abandoned after 90 minutes. I found 1 extra user in the file, kicked them out, and re-ran the report and it took 15 minutes (which is the slow side of normal).
Is there a setting somewhere I can check? This is causing some big problems and it's causing my other projects to get scrutinized, ONE user should NOT be causing this much delay, but every time the file is running slow if I kick everyone out and change nothing else, the performance is back to normal. (I now have a routine that permanently opens a recordset for each user since someone advised that, but I don't have enough feedback to know what difference, if any, it's making)
Thanks
-Lee
Tidak ada komentar:
Posting Komentar