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.
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,
August 14, 2019, 05:01 PM
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.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
August 16, 2019, 08:58 AM
JCARB
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.
August 18, 2019, 03:43 PM
Waz
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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
August 18, 2019, 11:05 PM
WFDevConsultant
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.
8.2.06 Windows, All Formats
August 19, 2019, 04:20 AM
Frans
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.
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.06 (Dev)
August 19, 2019, 09:55 AM
BabakNYC
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
August 19, 2019, 09:56 AM
WFDevConsultant
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.
8.2.06 Windows, All Formats
August 19, 2019, 09:57 AM
WFDevConsultant
You can test the initial portal load time by simple add the car fex to portal and load.
That itself takes 9seconds to complete.
8.2.06 Windows, All Formats
August 19, 2019, 10:07 AM
BabakNYC
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
August 20, 2019, 09:10 AM
jgelona
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.
