In-memory question

[#1]

Hi All,

I know QlikView is an in-memory tool and that if all the data can't fit in memory(meaning the memory on the server isn't big enough to hold the entire data set), then paging will happen. If this is how QlikView works, the how is it different form all the other products that work the same way? Please advice and thank in advance for the help!

[swuehl · Accepted solution]

I believe QlikView is not so much different from the products that work the same way, with regard to enough memory needed to cope with the data. But most "classical" BI tools just don't use in-memory technology, but store the data in file based databases and request more pre-aggregated values then do this on run time themselfes.

Though QlikView will compress your data quite efficiently, if your data model is too large for your built in memory, you will get in trouble.