Query Speed

[nerdlinger]

Using a parameter query with only 2 parameters feeding into the report is painfully slow when the table has over 50,000 records in it.

Is there any way to speed this up?

thanks

 

[kenhamady]

Are you using a QRY?
What is the database?
What are the data types of the parameter fields? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)