Hi

I am working on HTML report which has approximately >30000 records with about 15-20 columns.
Issue I am facing is that HOLD file itself is taking about 2 to 3 minutes to be created.
Currently I am using a ref cursor from oracle package to populate HOLD file.

Is there any way that I can avoid using the HOLD File and generate the report?

This message has been edited. Last edited by: Kerry,

Handling a hold file of about 30.000 records is not that much and will not be the cause of the delay. In this case I suspect that the delay is within the dbms, which is taking it's time to produce the records. And I would certainly not advise to display an html report of that size. IE will take a *very* long time rendering the report. Firefox may be faster, but still ...
For these kinds of reports I would look into the webviewer, or any other alternate way of presenting.

True,

I've got a HOLD file with also about 20 column and 800.000+ rows.
That's not the problem.

Getting the dbms to produce the correct rows to fill up the HOLD is what takes time.

quote:

Originally posted by Anmol:
Currently I am using a ref cursor from oracle package to populate HOLD file.

I don't know Oracle but in my experience with MSSQL the use of cursors REALLY slows things down. Perhaps there is a better method to get the result set you are looking for?

Again, I don't know Oracle but I found that I had to work with the "SET CURSORS" and "SET TRANSACTIONS" statements to improve performance.

Dan

This message has been edited. Last edited by: Dan Pinault,