Speed

rbuser

Hello,

I'm sure this has been posted many times, I just was unable to find it. I
recently upgraded from the BDE to Advantage and all my customers are
complaining about the speed, that it is significantly slower especially the
reports designed with ReportBuilder. I know I have seen someplace where
there were some steps that can be taken to improve the speed (or tweak it).
Anyone have any suggestions on setting I can check or possible ways to
improve the speed?

Thanks in advance,
Rodger

nicocizik

Rodger,

Now that you are using a database server, be sure you are not using Delphi
Parameters to link your datasets. Try using datapipeline linking instead.
You can also try turning off the Report Outline and setting
Report.CachePages to False. We have had reports from other users that in
larger reports, these properties may slow performance.

--

rbuser

> Now that you are using a database server, be sure you are not using Delphi
You mean in a Master detail report? If so I have removed the Dataset link
and switched them over to linking the pipelines. I still have parameters I
am sending to the SQL. To filter down the data returned (i.e.. only show
data between Date1 and Date2).

Thanks in advance,
Rodger

nicocizik

Rodger,

It is definitely the parameters that are slowing your performance. You will
need to create one large detail dataset to handle everything and order it
the way you need to aviod the use of parameters multiple times throughout
report generation.

--