Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
shamiul_islam
Contributor III
Contributor III

Qlikview slowness and huge size of QLIKVIEW file

I created a QLIKVIEW document which contains five transaction table. I have only two years data. But when I reload my script the file became 700MB approax. I load the data from SQL Server through SSAS tabular Model. The file is too slow to response when I open it from developer or web. How can I reduce the file  size? And also how can I solve the slowness issue?

Labels (3)
3 Replies
martinpohl
Partner
Partner

When open the file it is a question of your system performance(disk type, network capacity)

for server, you can preload the app so it is always in memory (beware of hardware resources)

To reduce datas: 

load only field you need (don't use select * from datasource but select field1, field2, fieldn from datasource)

 

jonathandienst
Partner
Partner

If you simply loaded five tables from your datasource, then your data model likely has a bird's nest of synthetic (composite) keys. These can take a long time to generate and can require a vast amount of space. But they also contain a mass of invalid or meaningless associations, so your document probably will not work anyway. If you can open the model in desktop, press Ctrl-T to look a the table viewer to see what you loaded.

Remember that a Qlikview is not a set of tables like a database. the entire model is interlinked and associated. So you may need rethink your model design and how the data is associated. You might also want to search for articles and blog posts in the community on how to build large dataset models.

BTW - 700MB is not especially large for a Qlik model. I have worked on several that have been 2-5GB in file size and even that is not the largest possible. But they do requires lot of RAM.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Brett_Bleess
Employee
Employee

Perhaps the following Design Blog posts may be of some further help, but if either of the other posts did help, be sure to use the Accept as Solution button where appropriate.

https://community.qlik.com/t5/Qlik-Design-Blog/Data-Modelling-Clarity-vs-Speed/ba-p/1473644

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

Here is the base URL to the Design Blog area in case you wish to search for other items on your own:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

There are hundreds of posts in this area by our internal experts, and they are mostly how-to related.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.