 |
|||||
|
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. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] WebFOCUS Application Load Times
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] WebFOCUS Application Load Times Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] WebFOCUS Application Load Times | Login/Join |
| Member |
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, | ||
|
| Expert |
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...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Member |
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. | |||
|
| Expert |
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...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Platinum Member |
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 | |||
|
| Guru |
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. | |||
|
| Gold member |
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) | |||
|
| Virtuoso |
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 | |||
|
| Platinum Member |
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 | |||
|
| Platinum Member |
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 | |||
|
| Virtuoso |
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 | |||
|
| Master |
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. | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] WebFOCUS Application Load Times
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] WebFOCUS Application Load TimesCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |