I want to know the qv data upper limit. Of cource ,I know it depends on RAM、CpU and so on. But what happens when the data size is bigger than RAM? In the other world, there exsits the proportion between RAM 、SIZE 、lines and so on. when RAM is 32G, then the upper limit? when RAM is 64,then?
Another question, if I use the SSD, what will happens and big influence?
My clients need to know these .So I need a document , please help. Thanks.
If the size of your qlikview application is bigger than your RAM it won't work. Even it's a bit lesser it won't make much sense because you need further RAM to calculate thing and to cache these calculations. The important point here is the (uncompressed) size of the qvw and not the size of your raw-data. The reason is that qlik used a quite effective way of storing the data which often results in compression-rates of 80-90% - essentially depending on the cardinality of the fields.
There is no practically way to pre-calculate the needed RAM consumption only with the raw-data size or the number of records - it will always depend on the data itself and how the datamodel is designed and the RAM consumption is especially not linear with the amount of data.