topic Re: 100 million rows database in QlikView

100 million rows database

Mon, 11 Feb 2013 15:00:30 GMT

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,

Re: 100 million rows database

vivientexier — Mon, 11 Feb 2013 15:07:08 GMT

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

Re: 100 million rows database

Mon, 11 Feb 2013 15:10:30 GMT

Thanks,

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

Thanks

Re: 100 million rows database

manideep78 — Mon, 11 Feb 2013 15:13:13 GMT

It depends on your RAM capacity.

Re: 100 million rows database

vivientexier — Mon, 11 Feb 2013 15:13:50 GMT

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...

Re: 100 million rows database

Mon, 11 Feb 2013 15:35:26 GMT

What is the optimum RAM for this size of document?

Re: 100 million rows database

vivientexier — Mon, 11 Feb 2013 16:55:59 GMT

This document may help you to understand what you need

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