Slow

rbuser

Our end-user tool with a report-explorer is extremly slow when
it is executed. We work against a ms-sql-2005 server.

Is there a way to fix this problem?


Best regards,
Terje Syversen

nicocizik

Terje,

We are going to need more information about your application and environment
to possibly track this down. There are numerous factors than can cause an
end-user app to slow down.

Which version of ReportBuilder and Delphi are you using?
Is your database on a separate server?
At what point do you experience slow processing? Loading reports,
application start, etc.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

I am using D2007 and the latest version of ReportBuilder.
The database is on another server but that should not cause any problems.
A query like this
(
select * from rb_folder
inner join rb_item on rb_item.folder_id = rb_folder.folder_id
)

is executed extremly fast, and this fetches all folders and reports.

The process is slow on ReportExplorer1.Execute.

Best regards,
Terje

nardmoseley

For RB 10 we added a ReportExplorer.ItemTemplatePipeline that enables the
report explorer to be optimize. See the ReportBuilder help topic for this
property. And see the RBuilder\Demos\EndUser Database examples.

--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com