[AccessD] Reports

Martin,

Go out for coffee!  The rest of the data is still loading and remember
that a page formats at least twice when it previews.  Access has to
process everything to get to that last page, and it is SLOOOOW.  You
would be better off using either a temp table in SQL Server or a temp
table in Access, but the SQL Server table will be the fastest, since the
processing on the server side doesn't involve Jet.  I've built these
monsters in Access when SQL Server wasn't an option, but don't expect
fast.

Charlotte Foust

-----Original Message-----
From: Martin Reid [mailto:mwp.reid at qub.ac.uk] 
Sent: Thursday, May 20, 2004 10:29 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Reports


What sort of time would I expect when moving from Page 1 to Page 500 in
a report. i.e cliecking to go to the last page??

Fairly complex report which is pulling data from SQL Server using a
Stored procedure. Opens in under 2 seconds but still takes forever to
move to the last page.

Given I need to move very quickly from page 1 to page 500 would it be
better to create an populate a local table with the date and take the
hit before the form loads??



Comments??


Martin

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com