HOLD Files take 15 minutes to run

[LeonelSanchezJr]

I have a report fex which returns the record set via a direct sql pass thru to Oracle in less than 15 seconds.

However, the report fex creates 5 HOLD files in order to manipulate / format the report. The HOLD file procedures takes over 15 minutes, therefore, my browser times out.

I have two choices:
1) Run the report deferred
2) Optimize the HOLD file procedures.

My problem is that the report fex resides in the REPOSITORY, therefore, I can not change its properties to "RUN AS DEFERRED REPORT ONLY".

Here is the scenario. The calling FEX is a parameter page which allows the users to select the desired parameters. Then, the user clicks on a SUBMIT button which calls the report FEX.

Help...

Thanks,

Leo ;-)

 

[WFGuru]

If the report is in MRE, you can always add a radio button or hard code the parameter to run deferred. That would however, only mask the real problem. My suggestion would be (b) to optimize the report. You must be doing something in at least one of your passes that is doing a table scan.

 

[focwizard]

Leo,

Based on the time it takes, I can only guess that you're retrieving LOTS of data. Can you post the query. There are optimization techniques (such as using TABLEF rather than TABLE), which might help.