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] WebFOCUS Application Load Times
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] WebFOCUS Application Load Times
 Login/Join
 
Member
posted
Hello,

Is anyone seeing 9+ second load times for dashboards. We have a case open with IBI and can't seem to get a resolution.

The data is in a SQL server 2016, data is highly optimized or very small in nature, however executives are seeing these long load times. This is not the page object load times, but actually starting the application itself on portal load.



https://imgur.com/DoyPybC

Edition
WebFOCUS Applications Edition
Product release
8.2
Service pack
0.3
Package name
wf011719a
Release ID
8203M
Build/GEN number
74
Build/GEN date
January 17, 2019 4:04:59 AM UTC
Application Server
Apache Tomcat/8.5.29

Best,

John C.

This message has been edited. Last edited by: FP Mod Chuck,
 
Posts: 2 | Registered: August 01, 2019Reply With QuoteReport This Post
Expert
posted Hide Post
We have the same issues and I think its addressed in 8.2.05.

This assumes you are using the repository for the fexes and not the reporting server.

Do you have lots of fexes with includes and includes including includes, etc ?

i.e. complex with lots of common code ?


We do and 9 seconds is common for us.

We have had a case open but was not resolved. Ended up moving to 8.2.05 fixed the issue.

The underlying cause for us it that the client ships a copy of every fex and include, whether its a duplicate or not.

This caused the extra "lag" for us.

Some of our fexes would have 40+files associated to the run, but would get more than 160 fexes sent to the reporting server for execution.

You can check this by doing traces in the session monitor on the Administration console diagnostics.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6104 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Member
posted Hide Post
quote:
Originally posted by Waz:
We have the same issues and I think its addressed in 8.2.05.

This assumes you are using the repository for the fexes and not the reporting server.

Do you have lots of fexes with includes and includes including includes, etc ?

i.e. complex with lots of common code ?


We do and 9 seconds is common for us.

We have had a case open but was not resolved. Ended up moving to 8.2.05 fixed the issue.

The underlying cause for us it that the client ships a copy of every fex and include, whether its a duplicate or not.

This caused the extra "lag" for us.

Some of our fexes would have 40+files associated to the run, but would get more than 160 fexes sent to the reporting server for execution.

You can check this by doing traces in the session monitor on the Administration console diagnostics.


Thanks Waz -- appreciate the response. Pretty frustrating to have a case open and not get a resolution. Originally it was our server problem, then a WF problem. No solutions given.
 
Posts: 2 | Registered: August 01, 2019Reply With QuoteReport This Post
Expert
posted Hide Post
I would suggest that you investigate yourself along these lines to see if it is similar to what we found.

At least you will have the evidence.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6104 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Did you check the Session Viewer? That will tell you where the time is being taken.
There are couple of things might causing this.
1) If you have more KPI's to load on the page, chrome has limitation of 6 request to run at a time. That might be cause of this too.
2) How long your queries are running in database?
3) Once you get the data, how long the fex is taking?

If you get answer for those then you will have your answers.


7.7.03/8.0.0.7
Windows, All Formats
 
Posts: 160 | Registered: December 27, 2013Reply With QuoteReport This Post
Guru
posted Hide Post
The portal itself takes some time to load, in the later versions of WebFOCU Sthis is getting better / faster.

Check with developertools in your browser (F12) the network statistics to see what is taking a lot of time. Also the sessionviewer in the WebFOCUS client helps to see which calls are taking a long time.


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 388 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
I've created a dashboard that has nothing but URL's (no fex fired off at load time) and it still takes around 10 seconds to load. Now that we won't be able to use View Builder, we don't have many other options than the slow dashboard.


WF 8.0.08 (Prod); WF 8.2.04 (Dev)
 
Posts: 59 | Location: OK | Registered: November 19, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Open Admin Console, Diagnostics and Look at the Session Monitor. It'll highlight any warnings and/or errors. Is this an application that was just developed or upgraded? You can also check the Reporting Server logs to see how the server is performing. Do you have this problem with a specific dashboard or is it every report and chart that behaves this way?


WebFOCUS 8206, Unix, Windows
 
Posts: 1658 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Portal initial load slowness is happening everywhere. Already we opened a case with ibi but no luck. One of the options we are trying is to move the WebFocus repository from cloud to local and that reduce the initial Portal load from 8seconds to 6seconds.


7.7.03/8.0.0.7
Windows, All Formats
 
Posts: 160 | Registered: December 27, 2013Reply With QuoteReport This Post
Platinum Member
posted Hide Post
You can test the initial portal load time by simple add the car fex to portal and load.

That itself takes 9seconds to complete.


7.7.03/8.0.0.7
Windows, All Formats
 
Posts: 160 | Registered: December 27, 2013Reply With QuoteReport This Post
Virtuoso
posted Hide Post
How many parameters does your portal have?
Are they all dynamic parameters?

Perhaps your parameter prompts need to be adjusted to show either a fixed list or tap into a smaller list of values table.


WebFOCUS 8206, Unix, Windows
 
Posts: 1658 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Master
posted Hide Post
I just wish that IBI would put the old dashboards back in the product. In our environment and the way we use them, their performance is far superior to the portal. IBI finally got it stable and working then they drop it for no good reason. Don't want to further enhance it? I have no problem with that, but don't just eliminate it.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 917 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] WebFOCUS Application Load Times

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