If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|