Performance Issue

[srilu]

Hi
I had a report, which will return more than 10k records. I have 5 groups in the report and i am using more than 20 running totals in the report. report is taking much time to return records. Is this because of too many running total fields? is running total takes more time than summary fields? which one is the best and fast?
thanks.
Srilu.

 

[kenhamady]

Neither of these should affect the spped of the RETURN of records from the database. That is determined by your WHERE clause, which is based on your record Selection Formula. Post your RS formula here and we might be able to speed it up.

But, if the records are returned, but the report is processing them very slowly, then I would look at these features. I would expect most summary fields to be a bit faster than running totals, but it probably depends on what type of summary and what RT options you have selected. I have never benchmarked them. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com