Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How much data can Qlik Sense use?

Hi,

is there a limit how much data Qlik Sense can use? For example i have a database with 30 tables and together 300.000.000 datasets (or records?). Is it to much?

regards

René

3 Replies
Uday_Pasupuleti
Partner - Creator III
Partner - Creator III

HI,

If you are processing large sets of data and your server specs are not massive then I would suggest to take  'Direct Discovery' route.

So that you can only bring the dimensions into qlik data model and keep the large fact table on the db.

https://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/DirectDiscovery/DirectDiscovery.htm

Thanks,

undergrinder
Specialist II
Specialist II

Hi Walter,

uday.pasupuleti‌ is right, you should use the direct discovery option.

By the way I made performance test recent with Qlik Sense, and with simple data model (1dim, 1fact), I stopped at 28 000 000 rows, and still works well and rapidly.

G.

Not applicable
Author

The scalability of Qlik Sense is well explained in the following document:

www.qlik.com/en/resource-library/qlik-sense-scalability


Interesting to note, I have seen a Sense app with well over 80Million records run with no lag at all