Crystal RDC 10 in VB6 very slowwwwww! Any Tips

[tconway]

I have been using RDC for several years, but with version 10 things seem to have slowed down a bit.

My application uses ado to retrieve data and displays the data in various text boxes and grids and so forth. So, the data is already loaded. The request to display a report is activated by a command button if the user wants a report.

Rather than pull data all over again, the report uses .ttx for data definition and the CDO as the data source populated from an array of data alreay displayed.

Yet still the report is slow, especially on the first report of the day. Subsequent reports are somewhat faster.

I should also mention that these reports are actually forms with very little data, such as one name and address with related info.

Any tips on enhancing the speed or possibly a faster techinque.

Sorry, I'm kind of stuck with Crystal, Data Dynamics Active Reports or changing to another reporting program is not an option.

I am using VB6, WinXP and SQL server and the machines are all Pent 4 2.5 Ghz 512RAM over 100GB of HD space etc. All patches and updates are applied.


Thanks

Tim

 

[synapsevampire]

Sounds like the hardware/software isn't a problem.

Since the first report is slow, it may be that the SQL Server cache is responsible for the increased performance there. It may be that the database is running more slowly now, have you compared the old reports speed lately?

Very slooooooooow and slowed down a bit doesn't really describe what has happened. Were they running in 10 seconds and now a minute?

Have you applied the service pack?:

http://support.businessobjects.com/fix/hot/si75/default.asp

I saw some blurbs that were similar to your concern, but not exactly.

-k