I Have a Qlik view report in which I am loading a 1gb qvd file. after doing the joins and all the final size of qvw file is 350 mb. I am having some performance issues also.
Now i need to load some more data. so the size of the qvd file would be around 3gb and the final size of qvw file will be more than 1 gb. is it really a good practice. How cal i deal this situation with out having performance issues. also will the qlikview personal edition memory support this much of data?
QV can support models of more the 1GB in size. The only limitations are those described by Marcus above.
>>How cal i deal this situation with out having performance issues
For large datasets to perform well, it is vital to have a properly designed data model that is efficiently structured and matches the questions that you are asking of the data,
>>also will the qlikview personal edition memory support this much of data?
Yes, as long as your desktop/laptop has sufficient RAM + CPU. With a 1GB data model (file size), you will may need as much as 16GB of RAM.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Qlik itself has no limitation unless 2 billions unique values within a single-field - this meant that only your resources on RAM + CPU will be a restricting factor. I assume that if you experienced any performance-issues that you didn't have a proper datamodel.
QV can support models of more the 1GB in size. The only limitations are those described by Marcus above.
>>How cal i deal this situation with out having performance issues
For large datasets to perform well, it is vital to have a properly designed data model that is efficiently structured and matches the questions that you are asking of the data,
>>also will the qlikview personal edition memory support this much of data?
Yes, as long as your desktop/laptop has sufficient RAM + CPU. With a 1GB data model (file size), you will may need as much as 16GB of RAM.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
