[AccessD] Reports

Out for coffee, in Belfast at 22.18pm, ha rather fight with this thing! LOL

Thanks. Am going to try that approach.

Martin


----- Original Message ----- 
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Thursday, May 20, 2004 10:11 PM
Subject: RE: [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
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>