Hi Lee,
What are your default Record-Locking choices in
Tool\Options\Advanced\default_record_locking?
What are the settings for Record_Locks in the
queries used for creating the 'report'?
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Lee-
>
> Opening a recordset and leaving it open on startup should make a world of
> difference. But you also need to take a look at the report. Even 15 minutes
> seems excessive. What recordsets are being used by the report and why are they
> so slow? Do you have appropriate indexes defined?
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> -----------------------------------
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Lee
> Sent: Wednesday, April 11, 2012 5:58 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Concurrent users causing MASSIVE latency issues
>
>
> 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