tune Query Reporter

[mpl]

Is it possible to tune the Query Reporter to run faster.

I have the problem on selects of 'only' 1000 records, the select and the export to csv take too much time for me.
The select is fast, but the output for csv/excel... is whery slow..

pleas give me a tip.

thanks.
I work on a Oracle8i Enterprise Edition Release 8.1.7.3.0

[This message has been edited by mpl (edited 22 October 2003).]

 

[Marco Kalter]

Exactly which part is slow, and how long does it take?

1. The query
2. Presenting the HTML
3. Exporting to a CSV file
4. Exporting to EXCEL

------------------
Marco Kalter
Allround Automations

 

[mpl]

the part who is very slow is the part where the records will be copied to excel or to csv.

per example:
I start a very simple select from one table witch returns 3663 rows:
time for the select ~ 7 seconds
time to load to grid ~ 7 seconds

but to export this records to excel it takes 250,97 seconds!!! (and this export needs 100% cpu!!!)

 

[Marco Kalter]

What about CSV? Surely this doesn't take this long as well?

I suspect that OLE/Excel is causing the problem here. A future release will probably omit OLE and will create an Excel file directly.

------------------
Marco Kalter
Allround Automations

 

[mpl]

Thank's...

I will wait for the new release, and I hope that this release will arrive soon....