Report Explorer Performance

rbuser

I'm encountering some real performance issues with the ReportExplorer.

Using the "\Demos\3. EndUser\1. Report Explorer" example:
time to start EXE: 80+ seconds
time to load 17K report in designer: 150+ seconds

This is over a cable connection from my home computer to the Oracle
database at work. What concerns me is that one of our customer's branch
offices is connected to the main office via a 56K line.

Is there something that I can do to resolve this?

Thanks in advance,

Ed Vander Hoek

rbuser

i'm facing exactly the same problem as my database grows. The problem is
that report explorer fetchs all the blobs fields and it is very time
consuming.

A solution would be to fetch only needed blob as the user try to open a
report.

sorry for my english...

rbuser

Olivier Ziller wrote:

Yes, that would be the best solution.

Some work arounds:

1. We can store the reports in the database, but cache the reports
locally. At start up the application would check for updated reports,
download them to the hard drive, and use Report Explorer with the local
files.

2. We can modify or rewrite the Report Explorer functionality ourselves.

Would anybody from Digital Metaphors care to comment?


You're English is better than some native speakers.

Ed Vander Hoek
Klein Systems Group

digitalmetaphors

Another alternative exists. If you use ASTA with the RB end user solution,
you can configure the SQL options set property on the ASTA CDS to
conditionally fetch BLOBs and memos and toggle it at runtime to get this
behavior.

We would probably have to rewrite the report explorer component to take into
account that the template fields are loaded on demand. You can try to fire
the query for the rbItems to retrieve the templates on demand using a custom
report explorer form and using events/methods available to it. We've
researched this before, but have not been successful at creating a solution
at this time.

Cheers,

Jim Bennett
Digital Metaphors

rbuser

Jim Bennett (Digital Metaphors) wrote:

Thanks for the response, Jim. I'll look into modifying the Report
Explorer next week. I'll let you know if I find any reasonable way of
doing it.

Thanks,

Ed Vander Hoek