Brad Marks
BradM at blackforestltd.com
Mon Sep 16 16:58:04 CDT 2013
Gary, I had not thought about anti-virus software getting into the act. I will investigate. I have done a compact and repair. The accdr file is the exact same file for both the Server and the stand-alone PC. Thanks, Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos Sent: Monday, September 16, 2013 4:34 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Job Duration Puzzler - Access 2007 Report Is there anti-virus software running on the server that might be scanning the Access file as it's running? perhaps something with the exceptions list to exclude the Access file data type was changed? Have you tried a compact and repair on the copy of the access database running on the server? Just tossing some things out there. GK On Mon, Sep 16, 2013 at 2:14 PM, Brad Marks <BradM at blackforestltd.com>wrote: > 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 > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Gary Kjos garykjos at gmail.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message was scanned by ESVA and is believed to be clean. Click here to report this message as spam. http://h0stname/cgi-bin/learn-msg.cgi?id=21C0628C9A.5D5F9