Report opens very slowly, query speed OK

[rightcoast]

Hello,

I have some reports in an Access DB (these were inherited from a novice developer). Prior to splitting the DB, the reports ran with good speed. I noticed a dip in speed after splitting the DB, and when run at the client (with the BE on the client's server and the FE on their local PCs), the performance is unacceptably slow. The query upon which the reports are based has good performance (even on their server) - 2 or 3 seconds. I've seen that there is a 13 to 16 second gap between the report_open event and the report_load event (on my PC) - any thoughts on what is causing this lag prior to running the report's query?

The reports have one subreport - removing this made no difference to the speed. Many of the report's controls have multiple nested IIf statements - would this impact report performance? That would seem unlikely to me as the lag seems to occur before the query is even run, but there must be some explanation for the poor performance. I've searched the internet, but not found any explanation or suggestions yet; hoping someone here can offer some insight. Thanks in advance for any help provided.

 

[gemma-the-husky]

Hi.

I have just had a horrible afternoon with this, trying to modify a report design until I realised what the problem was.

my printer is attached to my home network, and is slow to respond.

I had set this as the default printer, and that was causing the problem.

Set the default printer to a local one (even just one of the MS virtual printers), and the problem should go away.

Hope this helps anyone with this issue.

 

[hprwdvd]

I have the same problem. The printer is already set to the default network printer. The database runs quickly on my local drive, but slower on some other computers' local drives without the Full version of Access. Opening the first report is slow, but then in subsequent tries it opens in 1 second. It seems it just needs to get over the first try.

Do you know why this is??