[AccessD] Reports

My understanding is that the aggregate function COUNT is highly optimized so
a statement like:

Select count(ID) from TheTable Where George > Bill

...should be extremely fast...?

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Francisco H
Tapia
Sent: Thursday, May 20, 2004 12:00 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Reports


The time it takes to move from page to page depends in a large part on
what you're doing in your report.  Somethings I've learned are
easier/faster to make TSQL and Queries do instead of the report, counts
for instance and totals.  For some reason the code that Access uses to
come up with these figures are extremly sloooow

--
-Francisco




Martin Reid wrote On 5/20/2004 11:28 AM:

>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