Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Performance enhancement? (odbc)
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Performance enhancement? (odbc)
 Login/Join
 
Gold member
posted
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,


WebFOCUS 7.X.X, 8.X.X
Windows, All Outputs
 
Posts: 76 | Registered: February 02, 2016Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Depending on the RDBMS indexing the account_number field might speed things up.


WebFOCUS 8206, Unix, Windows
 
Posts: 1660 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
You can insert the hint.
SQL SQLORA SET HINT /*+ parallel(2) */  


TABLE FILE ...

Doc here


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1100 | Location: Toronto, Ontario | Registered: May 26, 2004Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 116 | Location: Seattle, WA | Registered: April 07, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
"Performance enhancement?"

LOLZ I was like dare I open this? Big Grin


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1110 | Location: USA | Registered: January 27, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Performance enhancement? (odbc)

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.