Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview document load slowly/lag when opening from web/window client for the first time

Hi All,

I have many complaints from the users that when they are loading some dashboards, they are facing delays when using web/windows client.

The programe (500kb .qvw file) will hang in the below screenshot for 10-15 sec during first load (everyday).

Users are using AD authentication.

qv_slow.JPG

I went to the server and view the event log:

The description for Event ID ( 100 ) in Source ( QlikViewServer ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: CAL usage: Using CAL of type "Named User" for user "AD\USER1". Named user cals in use: 5.

Does this have anything to do with the lag?

If not, what could have causes this?

Server information:

Product Information


Product nameQlikView Web Server x64


Client Build Number11.0.11149.0


Target Platformx64

Machine Information


Computer Name


Operating System VersionMicrosoft Windows Server 2003 Standard x64 Edition X64 (Microsoft Windows NT 5.2.3790 Service Pack 2)


.NET Version4.0.30319.1


Physical Memory7935Mb


Available Memory3506Mb

CPU Information


CPU 0Intel(R) Xeon(R) CPU E7320 @ 2.13GHz


CPU 1Intel(R) Xeon(R) CPU E7320 @ 2.13GHz


CPU 2Intel(R) Xeon(R) CPU E7320 @ 2.13GHz


CPU 3Intel(R) Xeon(R) CPU E7320 @ 2.13GHz
2 Replies
Not applicable
Author

hi,

it is hard to say if event log is related to the delay. One thing that you can try is to configure settings on QV Server for that document in following way: in QMC go to Documents>User documents>mark corresponding document and in Server>Performance tab for it take a look at 'Max Inactive Session Time' and 'Document Time' values. Also, mark 'Preload' checkbox, which will load document in the memory before first request for it arrived (see also help page for that tab on the server).

regards

Not applicable
Author

It sounds like your document takes a few seconds to load. You can configure the document so that it's always kept in memory (select the preload option on the document in QMC). You can also check if any OnOpen triggers, number of sheets and objects, and the data model to see if there is room for improvement.

The event log simply shows that a user is accessing the document.