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     [CASE-OPENED] How to improve download times of wfbiportalrun.jsp and views.bip?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CASE-OPENED] How to improve download times of wfbiportalrun.jsp and views.bip?
 Login/Join
 
Member
posted
We're an international logistics corporation and have developed a Customer Facing portal to provide Supply Chain Visibility to our customers. A WebFocus8 Key Performance Indicator (KPI) Dashboard is the centerpiece of the portal.

The KPI Dashboard is very slow to render, which has our customers quite upset. We've isolated the 2 files that cause the longest delays: wfbiportalrun.jsp and views.bip. They're taking about 7 and 8 seconds respectively to download (15 seconds total). They're not big files, around 20Kbytes each, so we're struggling to understand what's going on. As I mentioned, our customers are vociferously complaining and we need to really speed this up.

Does anyone know how to speed up the downloads, and/or force them to be cached in the browser?

thanks!
EK

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 8
Windows, All Outputs
 
Posts: 4 | Registered: March 09, 2015Report This Post
Gold member
posted Hide Post
I dont think its those files what are loaded but something else. I assume KPI dashboard is filled with charts? Have you tried debugging it with Fiddler?

It will show what traffic is there when page is loaded.

Also what version of WF8?


Release: WebFOCUS 8104, AppStudio: 8105
OS: Windows
Output: HTML,Excel,Active Reports
 
Posts: 89 | Registered: November 19, 2013Report This Post
Member
posted Hide Post
Yes the dashboard is filled with several charts. We're using the F12 key in our browser to watch the downloads. I understand that it could be a different file that's causing the delay, but we should be able to see that via the F12 key, correct?


WebFOCUS 8
Windows, All Outputs
 
Posts: 4 | Registered: March 09, 2015Report This Post
Master
posted Hide Post
Eric,

Yes, the network tab in the Developer tools on a browser will allow you to interrogate the network traffic and understand which calls are taking longer then others. In those 7 - 8 seconds though, WF is probably logging the user in, checking their Authorizations and performing whatever other session setup activities need to occur. If you don't need those things to occur, maybe you should consider sending the client directly to the page, and not through the portal. You can construct the call something like this :
quote:
'localhost:8080/ibi_apps/WFServlet?&|IBIMR_action=MR_RUN_FEX&|IBIMR_sub_action=MR_STD_REPORT&|IBIMR_fex=' || &DOMAIN || &SR_FOLDER || &REPORT_NAME


where your DOMAIN and SR_FOLDER make up the IBFS location of your report (WFC/Repository/TENANT/SUB_FOLDER).

If you hit the link to the page directly and its still taking a long time, then you know its not the Portal overhead that is causing the issue. Remember you can only do this IF your user is already logged in to WF.

If you still are convinced that the issue is with the overhead of the Portal and you absolutely need to cut that time down, then I would probably open up a case with IBI. They will probably refer it to their service consulting team though. At this point, I think you are going to be talking about faster hardware, better internet speeds, more efficient network sort of solutions.


Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
 
Posts: 750 | Location: Warrenville, IL | Registered: January 08, 2013Report This Post
Guru
posted Hide Post
Hi Eric,

Perhaps it's not the time of downloading, but time of waiting. In chrome press F12 and open the network tab before loading the page. Then when loading check where views.bip is and check the timing. If it's waiting (TTFB) then it means it's just waiting on server response.


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 454 | Location: Europe | Registered: February 05, 2007Report This Post
Member
posted Hide Post
Yes you're correct, I didn't articulate this very well in my initial posting.

There could very well be things happening on the WF8 server that's causing the delay, not the downloading of the files themselves. And it just so happens that those (slow) events occur the same time that the 2 files get downloaded. So a better to ask my initial question would have been:

Has anyone seen similar behavior with WebFocus 8 , and what tuning did you do to improve performance?


WebFOCUS 8
Windows, All Outputs
 
Posts: 4 | Registered: March 09, 2015Report This Post
Guru
posted Hide Post
We have speed issues that we have not fixed yet. But it was not has bad as trying to run the dashboards after the conversion from 7704. We rewrote all of Dashboards into Portals. We found going from ie8 to ie11 made it a lot faster also.


WebFocus 8.1.5
iSeries/Windows
DB2/SQL/Access
Dev Studio
App Studio
Maintain
ReportCaster
 
Posts: 341 | Location: Pembroke NH/Jericho NY | Registered: June 15, 2011Report This Post
Member
posted Hide Post
Thanks , its good to hear we're not the only company seeing these issues.

We never used 7, we started on WF8 so there's no legacy cobwebs to worry about. Also, this is customer facing so we don't have much control over what browser they use. That being said, we state in our Portal that we only support IE9 and higher. Still, we're seeing brutally slow behavior regardless of the browser -- chrome/firefox/IE/Safari, WF8 is crawling in all of them.


WebFOCUS 8
Windows, All Outputs
 
Posts: 4 | Registered: March 09, 2015Report This Post
Guru
posted Hide Post
It's quite frankly just a matter of measuring. When you load a portal, multiple requests are fired at the client, from the client there are requests to the reporting server and the repository. Everything can have effect on the total performance. What kind of repository do you have, is it on the client server, wat kind of sql requests are fired with the reports? Are these requests fast?

Could you run the query for just views.bip isolated? When I do this for a big portal it takes 1,6 seconds.

Just use the developertools on chrome and firefox.


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 454 | Location: Europe | Registered: February 05, 2007Report 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     [CASE-OPENED] How to improve download times of wfbiportalrun.jsp and views.bip?

Copyright © 1996-2020 Information Builders