Limiting records viewed for performance...

[fdgsogc]

Is there a function in Crystal that will go to the database and return only enough rows for the first page, and then retrieve other rows as the user navigates to new pages?

I have a report that has 30,000 records. It takes almost a minute to come on screen. I know my view is likely not efficient. But I was wondering if there was such a function regarding getting only enough data to fill the first page.

Using Crystal 9 on Win2K.

 

[synapsevampire]

Please post technical information:

Crystal version
Database/connectivity used
Example data
Expected output

30K rows is relatively small, it sounds like the database/query is inefficient, or your doing a good deal of the processing within the report.

Given that you haven't shared any technical information, it's hard to say.

-k

 

[fdgsogc]

Actually, the report returns 30,000 out of a table with 200,000 plus records.

Crystal 9.2.3.970
MS SQL 2000 db
ODBC connection

I cannot do my filtering of the data with the database view because the records are being filtered by the userid which I capture with a logon procedure before I pass them the URL for the report. I then append their userid as the filter criteria as a parameter in the report.

The question is can I have Crystal return the top 30 records and then on clicking next page return the next 30 records or is my only recourse to improve the view/query?

 

[synapsevampire]

I think that you'll have to optimize the query.

By passing the query to the database, you are filtering on the database.

Check the Database->Show SQL Query to verify that everything is being passed to the database from the record selection formula(s).

You also might take a look at the indexing to see if you can improve performance that way.

-k