100 million rows database - Qlik Community

Report Inappropriate Content · ‎2013-02-11

Hi All,

I have a 100 million rows database and I have to load it in Qlikview. Anybody knows if qlikview can handle this big database?

Thanks,

vivientexier · ‎2013-02-11

It depends of your fields. But, 100 million rows is not rare. QlikView can handle much more if you have a good server

Report Inappropriate Content · ‎2013-02-11

Thanks,

Could you please tell me about the server specs that you mean?

Thanks

manideep78 · ‎2013-02-11

It depends on your RAM capacity.

vivientexier · ‎2013-02-11

Unfortunatly there is no magic formula to answer this question. It depends of a lot of parameters. Size of all your data, your modelisation, number of users...

Report Inappropriate Content · ‎2013-02-11

What is the optimum RAM for this size of document?

vivientexier · ‎2013-02-11

This document may help you to understand what you need

http://community.qlik.com/docs/DOC-3728