Report Explorer Slow to open?

rbuser

Hi..

I am using Delphi-6 Ent with RBuilder7 Enterprise Edition.
I am connecting to an Oracle-9i Database using the DOA components (rbDOA76).

I have a problem with the Report-Explorer taking as much as 1 minute to
open.

My RBFolder & RBItem tables have very few records in them and RBFolder is
indexed.

When I ran the Oracle monitor I see the following:

SELECT RBFOLDER.*, RBFOLDER.ROWID FROM MAISY.RBFOLDER
ORDER BY NAME

SELECT RBITEM.*, RBITEM.ROWID
FROM MAISY.RBITEM

And then a series of Query.next (Some of which are taking 20 to 30 Seconds)?

Why is this? what can I do to speed this up?
Everything else (other queries and reports in RBuilder) run very fast?


Many Thanks
Shahine Ghanbarzadeh

nicocizik

Shahine,

One reason this may be running slowly is that the template files being
loaded are large. Try creating a few small template files and testing with
them. If that speeds things up, then try filtering the dataset to show only
the item name without and of the rest of the template. Then when a user
selects the name in the report explorer, select the item and pull the rest
of the template information off the database.

--

rbuser

Thanks Nico for replying.

If I ommit the "Template" field from the sql statement then Report
Explorer.Execute fails ?
How can I execute the Report Explorer?
What do I set the Report Explorer.ItemFieldNames.Template to ?

Many Thanks
Shahine..

nicocizik

Shahine,

Yes, you are right. Omitting the template field is not possible using the
ReportExplorer. I'll research a work around for this and post my results
here.
--