Qlikview in-memory processing Work
How does Qlikview in-memory processing Work:
With in-memory database, all information is initially loaded into memory. It eliminates the need for optimizing database like creating indexes, aggregates and designing of cubes and star schemas.
Qlikview uses the compression algorithms which reduce the size of in-memory data than what would be needed for hard disks. Users query the data loaded into the system’s memory thereby avoiding slower database access and performance bottlenecks. QlikView has an inference engine that maintains associations in the data automatically. It calculates aggregations on the fly as needed for use by multiple people. It caches data in memory.
Memory and CPU sizing is very important for QlikView, end user experience is directly connected to the hardware QlikView is running on. The main performance factors are data model complexity, amount of unique data, UI design and concurrent users.