View Single Post
  #1  
Old April 27th, 2010, 01:16 PM posted to microsoft.public.access.tablesdbdesign
Kieran H
external usenet poster
 
Posts: 2
Default Slow running reports

I'm running an Access based reporting application in two
environments. The older, MS Access 2000 version has been running for
years without issue. If I run the same report in both I get the
timing results below.

Please note that for this example the pass-through query runs in
approximately the same time on both versions circa 3-4 seconds and is
only returning 40 rows of data.

My question is why is MS Access 2007 taking 16 seconds to render the
report. I fully appreciate the devil is in the detail, I am just
wondering whether there are known issues that would explain this
behaviour.

(Just to make things interesting if the query is run as a maketable
query and the report is pointed at the newly created table if both
events are sequenced it will also run in circa 8 seconds. Currently
the report uses the pass-through query as the data source)


MS Access 2000
Windows 2000 & XP (mixed)

Reporting application captures report type & report parameters and
calls SQL Server 7 stored procedure for required data

Data returned to MS Access and rendered in MS Acccess report

Report takes between 6-8 seconds to render report

MS Access 2007
Windows XP

Reporting application captures report type & report parameters and
calls SQL Server 7 stored procedure for required data

Data returned to MS Access and rendered in MS Acccess report

Report takes between 16-18 seconds to render report!

Any thought would be appreciated

Cheers

Kieran