Focal Point
[CLOSED]Performance tuning in webfocus

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4427056386

August 30, 2016, 02:27 PM
Developer
[CLOSED]Performance tuning in webfocus
Can any one tell me how to do Performance tuning of a webfocus report to increase

This message has been edited. Last edited by: <Emily McAllister>,


WebFOCUS 8202
August 31, 2016, 08:28 AM
BabakNYC
What database are you writing reports for? Oracle, SQL, SFDC?

What version of everything?

More details about the type of reports you're trying to optimize would be very helpful. If you're using relational dbms, you might want to search for Optimization in the doc.


WebFOCUS 8206, Unix, Windows
August 31, 2016, 05:34 PM
eric.woerle
My suggestion would be to start by looking at the SQL generated. Here is some code that can help you do that.

 
 SET TRACEOFF=ALL
 SET TRACEON=SQLDI
 SET TRACEON=SQLCALL
 SET TRACEON=SQLAGGR//CLIENT
 SET TRACEON=STMTRACE//CLIENT
 SET TRACEON=STMTRACE/2/CLIENT
 SET TRACEUSER=ON
 SET TRACESTAMP=OFF
-* XRETRIEVAL defines whether you want the SQL to be passed to the DBMS or not.  Uncomment the below set command if you don't want the query to run 
-* and only want to see what would be generated
-* SET XRETRIEVAL=OFF 


If this isn't written efficiently you will need to look at the errors listed as to why and adjust accordingly. If the SQL looks correct, then you will want to look at the possibility of Indexes in your database or performance tuning your tables.

As Babak mentions, without more direction there isn't much more we can suggest.


Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
September 01, 2016, 11:46 AM
Kevin W
After that it is tuning things within WebFocus. Simple things that deal with the internal matrix. For instance if you have 500 fields don't make 499 of them BY fields while printing one. That means it has to sort the Matrix 499 times. But again, more info is needed.


WebFOCUS 7.7.05 (Someday 8)
Windows 7, All Outputs
In Focus since 1983.