I have a dashboard with 6 panels run off a calendar control. When I change dates the 6 panels coming back inside 3 seconds.

When I first go into the dashboard it takes over 20 seconds. If I go in, leave and back it takes 5 seconds as long as I am in the same browser session.

Does anyone have any ideas at areas I can look at to speed the initial load of the dashboard?

Fernando

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

I have previously resolved the problem of dashboards running slowly by using Report Caster to run nightly jobs and create hold files. We created fexes for graphs and charts to run against the hold files and performance was much improved. Good dashboard design should dictate that the data would load as quickly as the browser. Sorry that these details are not more more specific but, I no longer have access to the actual fexes.

Fernando, is it possible there's something loading into BI Dashboard when you start the browser session, some Java stuff or an XML file for the calendar? Subsequent dashboard activity uses the browser cache - just an idea...

Geoff,

The fexes run quickly. I can prove it by changing a date and get data back quickly.

The dashboard loads quickly if I am going into it a second time. It's the first time that I go in that very slow.

Fernando

How long does it take to load if you log in a second time if you close the original browser?

It takes just as long to load a second time if I close the browser. It only goes quickly the second if you are in the same browser.

It is also slow if one browser opens and then a second browser opens. Both are slow.

Fernando

Francis,

That is possible. If it is the case, how can I speed that up? I tried to load the dashboard off a hidden iframe on the home page, but does not help. Perhaps it something to do with the iframe belonging to a seperate session.

Fernando

Examine what's happening in each of the six panels.

Are you working with Internet Explorer 7 on Windows Vista? Isn't that the worst combination in the world?

The improved performance is due to the hold file being located internally (not crossing domains). Are you having to validate when you open up a new session with you dashboard? Is there security attached to the database you are querying your dashboard from?

Goeff,

The database does have security, so maybe some caching happening there. The dashboard also has security thru active diirectory and IIS and tomcat via the documentation on trusted authenticating. Maybe some caching there.

I've asked one our network guys to help me with some tracing on that end.

Fernando

Francis,

I haven't had to endure that combination. You have that and WebFOCUS 5.3. Odd combination there.

Fernando

Solution,

We had a java program that was gathering the user group. The server it was on was decomissioned. Reconfiguring solved the issue.

Fernando