Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Report running slow

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Report running slow
 Login/Join
 
Gold member
posted
Hi All,

I run the report from the Launch Page. It is taking atleast 15 minutes to genrate the report, It used to take not more than 2 minutes earlier.

Could anyone tell what might be the issue here, Where do I have to look for the problem to be resolved.

Thanks,

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


In Focus since 2008
WebFOCUS 8.2.0.1
Windows 7 - IE,Chrome,Firefox
Excel, PDF, HTML, AHTML, XML
JavaScript, jQuery, D3.js, Highcharts
 
Posts: 79 | Location: New York | Registered: February 04, 2010Report This Post
Guru
posted Hide Post
If you are going against a relational database you need to trap the SQL to see what is happening with your report. There are a number of posts on this topic in the forum. The most likely problem is your SQL is deoptimized. There are several ways I can think of that this might happen.


(Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats)
 
Posts: 391 | Location: California | Registered: April 14, 2003Report This Post
Platinum Member
posted Hide Post
Check-list

1) Did pgm change recently?
2) Did database/table/Indexes get altered recently?
3) Did volume of qualifying data change recently?

If these are OK, start actual code review

4) -EXIT at each step in code and see which step seems to have increased in time.
5) If relational db, capture SQL and run some Explains.

Still do not see a problem? Pray and comeback next day with a fresh outlook to start over.

Sandeep Mamidenna


-------------------------------------------------------------------------------------------------
Blue Cross & Blue Shield of MS
WF.76-10 on (WS2003 + WebSphere) / EDA on z/OS + DB2 + MS-SQL
MRE, BID, Dev. Studio, Self-Service apps & a dash of fun !! Music
 
Posts: 218 | Location: Jackson, MS | Registered: October 31, 2006Report This Post
Guru
posted Hide Post
As part of defensive programming, I will often add a DM step to grab the time after each of various steps and then -TYPE the &vars at the end of the procedure such that the elapsed times are available by a 'view source.'
In so many instances, databases are optimized for maintenance, not reporting, and WF gets blamed for the glacial response.


jimster06
DevStu WF 7.6.11
W7
HTML, PDF, EXL2K
 
Posts: 252 | Location: USA | Registered: April 15, 2003Report This Post
Expert
posted Hide Post
Do your SQL Trace and copy that in to a SQL tool (SQL Developer or something like that) and do an "Explain Plan" to see where you may have a database / table / JOIN issue. Perhaps someone is hold the tables open as exclusive?




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Gold member
posted Hide Post
I have made a few changes on the code. all other reports in that domain which uses same tables are taking less time to execute.

I open the view source, but I dont know what exactly to look for in it, other than parameter passing.
I am new to WF, please help by giving all options, different scenarios.


In Focus since 2008
WebFOCUS 8.2.0.1
Windows 7 - IE,Chrome,Firefox
Excel, PDF, HTML, AHTML, XML
JavaScript, jQuery, D3.js, Highcharts
 
Posts: 79 | Location: New York | Registered: February 04, 2010Report This Post
Platinum Member
posted Hide Post
Performance depends on knowing your data (tables, joins, indexes, etc) and also your server/network configuration, bandwidth etc.

If this program is long enough, did you try doing a -EXIT after each step to identify the bottle-neck?

Did you try having your DBA run an "Explain" on the executing query(ies)?

If it is a short piece of code, post it anyway. It will be difficult for an outsider to suggest performance improvements by looking at the code unless it is a blatant mis-step.

Sandeep Mamidenna


-------------------------------------------------------------------------------------------------
Blue Cross & Blue Shield of MS
WF.76-10 on (WS2003 + WebSphere) / EDA on z/OS + DB2 + MS-SQL
MRE, BID, Dev. Studio, Self-Service apps & a dash of fun !! Music
 
Posts: 218 | Location: Jackson, MS | Registered: October 31, 2006Report This Post
Platinum Member
posted Hide Post
If nothing else works, it would not be a bad idea to open a case with IBI.

While it is not necessarily a techincal issue, IBI tech-support had been gracious with code help for us in previous instances.


-------------------------------------------------------------------------------------------------
Blue Cross & Blue Shield of MS
WF.76-10 on (WS2003 + WebSphere) / EDA on z/OS + DB2 + MS-SQL
MRE, BID, Dev. Studio, Self-Service apps & a dash of fun !! Music
 
Posts: 218 | Location: Jackson, MS | Registered: October 31, 2006Report This Post
Expert
posted Hide Post
Re: Blue Zone's and Doug's posts, since you changed the program and are new to WebFOCUS, you may have disrupted what WebFOCUS is sending to the backend data base engine.

Put the following lines at the beginning of your program:
SET TRACEOFF = ALL
SET TRACEON = SQLAGGR//CLIENT
SET TRACEON = STMTRACE//CLIENT
SET TRACEON = STMTRACE/2/CLIENT
SET TRACESTAMP = OFF
SET TRACEWRAP = 78
SET TRACEUSER = ON
SET XRETRIEVAL=OFF
then change your output to HTML. Run the program. Do a view source. Scroll to the bottom. You will see the generated SQL. If you see more than one SELECT statement, you will see error messages above that will indicate what the problem is. If you don't understand the messages, please post them and we can help you.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Report running slow

Copyright © 1996-2020 Information Builders