Slow to Open

rbuser

When viewing a report for the first time there is a long pause while RB
looks at the table structure. Is there a way to prevent this from happening
when just viewing a report? I can see needing to check the table structure
for the designer but not the viewer.

nicocizik

Hi Richard,

When ReportBuilder previews a report it simply accesses the data it is
connected to. Any delay is usually caused by a slow network connection or
DB access. Which version of ReportBuilder are you using and what type of
application are you running?

--
Regards,

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

rbuser

We are using 10.6 and the application we are running is one we are building.
The example of the delay upon first use is if you open the designer and go
to the Data tab and attempt to change a datapipeline. First attempt has a
pause while all future access is instant.

nicocizik

My first suggestion would be to upgrade your version to 10.09 as we may have
made some minor changes that could help.

By the "type" of application you are running, I was referring to an end-user
app, or a simple report preview.

When you add or change a pipeline in DADE, ReportBuilder needs to re-access
the database and gather the schema. This is cached in memory making
subsequent accesses quicker however the initial access is as fast as your
database.

--
Regards,

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

nardmoseley

RB 11 includes performance improvements for the meta data access.

Try downloading a trial version of RB 11 and perform the same test.




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

rbuser

It appears to always access the schema though even though the datapipeline
is unchanged. All we are doing is printing the report.

Is there a way to stop it from accessing the schema when it shouldn't need
to.

nardmoseley

The query definition contains an object based description of the SQL. To
generate the SQL command text the database meta data is used. For RB 11 the
performance has been optimized.


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