Slow performance on system when report builder printing

rbuser

Hello,

I use report builder version 7.02 with Delphi 5 and Mssql 7.0 with BDE. I
have a report that takes 30 pages, when the report builder calculates the
report (preview mode) , i cant do anything in the database, i send sql
queries to mssql and i get time out message. The system performace slows
down dramatically (i use p4 1.8GHz with 512MB). Also while the report
builder constructs the report, the other threads of my application stops
working.I don't use the background printing property in then report builder.
The problem is both in preview mode and when you try to print the report to
the printer.

Is there something that i can do, so report builder don't slow too much the
performace of the system.


Thanks in Advance
Chris Alexioy

nicocizik

Chris,

This is not a known issue. If you try to access your data directly from
your Delphi application, does the speed increase? Check your BDE settings
and be sure that your BlobToCache and BlobSize entries have sufficient
values. You may want to check your application for memory/resource leaks as
the BDE is known to leak memory. Also, you might want to try switching to
ADO. In our experience, ADO has worked better with MSSQL than BDE.

--