[AccessD] Job Duration Puzzler - Access 2007 Report

Brad Marks BradM at blackforestltd.com
Mon Sep 16 14:14:46 CDT 2013


All,

We have a high level Access 2007 Report that is generated every night.
The data for this report is pulled from a number of SQL-Server database
tables. 

This report is automatically generated nightly on a server with these
specs -
MS Window Server 2003 R2 Enterprise Edition SP2
2.50 Ghz
12 GB Ram

About a month ago, I noticed that the "run time" for generating this
report went from 8 minutes to 20 minutes.  Everything works fine, except
that the run time has more than doubled.

I can also run this same report on a stand-alone PC with these specs -
Windows XP SP3
2.50 Ghz
3.25 GB Ram

When the same report is generated on this PC, the job runs for about 8
minutes.

Over the weekend, when nothing else was running, I conducted a number of
tests to confirm what I was seeing.

The results were consistent.  The generation of this report takes more
than twice as long on the Server as compared to the PC.

I am very puzzled and not sure where to look.

I don't know why the run times went up dramatically on the Server.

I don't understand why the run times vary between the two boxes.

Any insights or advice would be most appreciated.

Thanks,

Brad    
   





More information about the AccessD mailing list