From: Kieran H on 27 Apr 2010 08:16 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
|
Pages: 1 Prev: Who is This STEVE... ? Does he really help.. Others Next: Junction Tables |