Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
noman212
Creator III
Creator III

Slow behaviour of QVW files

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

as.png

6 Replies
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable

Hi,

Check sheet properties>Objects>Find which object consuming more Memory usage

Hope it helps!!

marcus_sommer

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

vikasmahajan

Moreover to this is pre-load option is enabled if not please enable the same and check the performance.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
jonathandienst
Partner - Champion III
Partner - Champion III

It would also be useful to show the tables view and some stats about the tables and keys. Some things to look for:

  • very large link tables - link tables with high cardinality can affect performance adversely. Merging fact tables may help.
  • long string / high cardinality keys (especially concatenated composite keys) - these increase the memory requirements and can impact on performance. Autonumber() may help here.
  • Date fields that are string values rather than dates, which means that date display and sorting requires continual calculation. Convert string date fields to numeric date values wherever possible.

For tuning and performance improvements, try options and test, test, test. YMMV

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
rupamjyotidas
Specialist
Specialist

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.