Slow running reports

K

Kieran H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top