Slow Reading Really Records

[UltraSmooth]

I developed a report in Crystal 8.5 connecting to a SQL Server (well the MSDE engine). The report is actually using a stored procedure. The stored procedure takes only a 4 or 5 seconds to run but the report takes forever reading in the records (can be upwards 50000 records). It seems to read about 100 records at a time.

I installed the latest version (Crystal Reports 2008) to test against and get the same issue. I checked the Performance Statistics and have attached a screen-shot below.

Anyone have any idea why it's so slow reading the records in? There are no complex formulas.

Any help would be appreciated.

 

[Turkbear]

Hi,
What connection method are you using?

Check to see if it has parameters that can be modified regarding buffer size or row limits.



To Paraphrase:"The Help you get is proportional to the Help you give.."