Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Cmmunity,
I am stuck in a problem with one okf my QVW file sized 1.12GB.
the QVW behaves very slow response when selecting multiple months, and when it goes to years selection it become not responding on server and on QLikView Access Point it lost connection to the server or session time out.
Details of RAM and CPU is attached.
we are already using best practices and developed facts and dimension tables.
from one of Community blogs we also developed transfomation and Presentation layers as well but not succeded.
Kindly suggest some ideas how to overcome this issue.
Regards
Noman khan
1) Must have Millions of records, Try to convert to qvd and then load. Meantime, Create whatever fields required from UI
2) Can you please share the screen of Start Task Manager --> Performance Tab
Hi,
Check sheet properties>Objects>Find which object consuming more Memory usage
Hope it helps!!
Please provide some more informations like the number of records from the fact-table and if compression is enabled and post a screenshot from the tableviewer, from the object which needs the most time to calculate and which expressions are in use there.
- Marcus
Moreover to this is pre-load option is enabled if not please enable the same and check the performance.
Vikas
It would also be useful to show the tables view and some stats about the tables and keys. Some things to look for:
For tuning and performance improvements, try options and test, test, test. YMMV
Download document analyzer. DO a analysis of your application
http://qlikviewcookbook.com/?s=analyzer
It will help you in the the recommendation you have received so far.