topic Basic question? in QlikView

Basic question?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I Have 16GB Ram

in oracle data base I have size of the data is 50 gb then how much time it will take to load the data ?

how much ram it will consume ?

Note: No user is hitting to the database . I am the person who is connecting to DB

Re: Basic question?

andrespa — Tue, 08 Mar 2016 15:44:06 GMT

Hi, it depends on the complexity of the queries and how the data model is build but I would say that it will take not less than 5-6 hours.

But again, this is a rough aprox, cause it depends of a lot of factors (like your I/O bandwith if you're loading from a server)

Hope it helps,

Andrés

Re: Basic question?

Anonymous — Tue, 08 Mar 2016 15:50:05 GMT

The answer is the infamous "it all depends.....".

Generally to load the data the bottleneck will be the constraints of extracting it from your database and transferring it where the QV load process is running. Without a good understanding of your infrastructure it is impossible to even guess. But for your data volumes an incremental load would recommended.

For RAM here is some guesswork with assumptions :

Half of your 50 Gbytes is indices which leave 25 Gbytes
Only 40% percent of you data will actually be needed which leaves 10 Gbytes
QlikView data de-duping [aka compression] will reduce it by 90% when loaded into memory which gives 1 Gbyte RAM consumed

This really is guessing given the limited info given so I make no promises at all that is even vaguely correct.

Re: Basic question?

Anonymous — Tue, 08 Mar 2016 15:50:49 GMT

Yes I agree

can u give some size of ram like in avg cases

I have the I/o are meadium range parameters

Re: Basic question?

andrespa — Tue, 08 Mar 2016 15:55:18 GMT

I agree with Bill. It depends, but maybe what he says make sense.

Cheers,

Andrés

Re: Basic question?

Anonymous — Tue, 08 Mar 2016 16:00:28 GMT

... and then you would have to add on 10% to the RAM for each user that access it via AccessPoint.