Discussion Board for collaboration related to QlikView App Development.
We are experiencing some problem with the load time for a qvw file, when users are accessing it with Internet Explorer through the access point. Once the file has loaded, the response times are ok.
The QVW file is only 176 MB (compressed), Qlikview is version 11.20.1225.0 SR5 64bit
The file has about 70 tabs, the tab row is hidden and sheets are activated by buttons or text fields with actions,
there is no limited user access (everybody can access everything), on each sheet the graphs and tables are hidden (by variables or selection requirements, also calculated conditions used), we use a lot of sheets to offer the users the quickest way to what they want to see (without having to manually select or filter). Users land on a landing page with only 3 textfields (1 with action) . Server has recently been updated and has about 20gig, document is pre-loaded, throtteling is off, ...
Only somewhat strange thing is in the file's script, where the data is taken from another qvw file (Binary ..\filename.qvw;) (this has to do with company's history, how the new file was created, upon an existing old one, so on reload the old file loads, followed by the new one which has some addional script like drop fields,bundle load images, and so on)
Now every user who accesses the file with internet explorer experiences some delay 30-40sec before the file's landing page is loaded.
When I access the document directly (on server or locally) the page loads in about 5-6 sec
Any ideas? Some are saying the timestamp should be divided in time and date seperately, some are saying the file's structure has too many tabs so the xml is too big, some are saying the qlikview version should be updated, some are saying the anti virus is the problem, ...
There are already a lot discussions about this issue, have you already tried some?
Normally we can check the loading time as below:
1. Check the loading time of the dash itself.
As you have 70 tabs, and a lot of triggers, it is possible that the load take long time.
You can check the "CalcTime" for each objects in the dash in Setting->Document Properties->Sheets.
As you mentioned it only takes about 5-6 secs when you login from server or locally, and is this always the case, or only sometimes? And if you checked the "CalcTime" and if it always take only 5-6 secs from your end, then we will confirm that is some problem with the loading process in the server.
You mentioned that the file has script takes data from another .qvw file, as when you access the dash, it will not reload data from script, so this dose not matters.
2. Check the setting problem in the server.
Is the problem new after update the server or it always exist even in the old server?
You can check some discussion related to server side setting here.
I think the differences between your access of 5-6 seconds and the users with 30-40 seconds will be within the network-traffic including the effects of firewalls, proxy-server and similar things (and which might change over the time). Beside them I would disable the compression because it saved only space on the storage but increased the storing- and opening-times.
Thanks for your response. Calc times already been checked and also run Document Analyzer to find the weak spots. Almost everything is tuned up now (still need to make formulas identical to each other though) and there are no slow loading charts or objects. Will need to check server settings...link you provided is not existing any more...have you got another?
Latest finetuning of the file gives me access time of 5 sec local install and 19sec through access point with firefox (Internet explorer tends to load more slowly)
Indeed will need to check server settings and network settings to figure this out...
(Local tech guys claimed the problem to be the quantity of tabs in the file)