First report takes very long

rbuser

Every first time I open a report it takes very long (about 30 seconds or
more). Also in the designer if I want to add a query it takes long to open
the assistent window.
We are working an a oracle database with more then 300 tables. It seems RB
loads the whole list of tables, in the designer and the first time when a
report with db connection is open.
Is there any way to speed it up?

ReportBuiler 7.04
Delphi 5

--
Mit freundlichen Gr??en
Sven Langenkamp

CT Datentechnik GmbH
Eschenstr. 2
D-31582 Nienburg/Weser
Germany

Telefon: +49 [0] 5021 - 9724-15
Telefax: +49 [0] 5021 - 9724-18
http: www.ctdatentechnik.de
e-mail: langenkamp@ctdatentechnik.de

nicocizik

Hi Sven,


How large is this report and how many records are you accessing? Is this a
two pass report? Are you accessing data across a network? Is your data
indexed?

If you are using the enduser solution, you may try using the Data Dictionary
to limit the number of tables that are available at run time for your users.

--
Regards,

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

rbuser

It's not a problem of the amount of records or something. Before the report
is opened and the data will be loaded, it takes much time. Now I know where
it happens:

When I set the SearchExpression of a auto search field. This takes more then
a half minute the first time.

After that when I'm previewing the report, everything is fine and it does
not take long. So, reading the data records is very fast. Settings the
SearchExpression is the problem. But why?
Currently I can not go deaper into the source. I will try that tomorrow.

Any ideas what can cause this time problem?