I have a report. It takes 30 seconds to run but I want the report little more quick.
when I run a sample query in query tools:
select * from default_vw where account_number = '12345';
It takes 3.50 seconds
In App Stdio : the response time is 5 seconds for simple table request.
and when I use parallel hints
Select /*+ parallel(2) */ * from default_vw where account_number= '12345'; takes 1.25 seconds.
My question , How can I cut down my response time.
Can any one please suggest me a good approach in solving this.
Thank you all.This message has been edited. Last edited by: FP Mod Chuck,
Depending on the RDBMS indexing the account_number field might speed things up.
WebFOCUS 8206, Unix, Windows
You can insert the hint.
SQL SQLORA SET HINT /*+ parallel(2) */
TABLE FILE ...
"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
Adding this to your EDASPROF.PRF can also help:
ENGINE SQLMSS SET FETCHSIZE 5000
Change SQLMSS to SQLORA if you are using Oracle.
WebFOCUS 8.2.03 - Production
WebFOCUS 8.2.04 - Sand Box
Windows 2012 R2 Server
HTML, PDF, Excel
In FOCUS since 1980
LOLZ I was like dare I open this?
8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
|Powered by Social Strata|