Large QVD about 2 GB , Consequences.

[agni_gold]

I have loaded the Data from Oracle Database and it will take about 1 Hour to load about 13 Cr Data.

Size of QVD is 2 GB

what are the factors for Data loading in Qlikview , Their Advantages and DisAdvantages.

[alexandros17]

If you load a qvd (Optimized) that is you load it as is, without queries and without elaboration on fields it is really quik and time saving. After you have load data you may reload with other changes. On the other side, you need a lot of memory (Ram) to load 2 GB of data, the more you load the more it slows if memory is not enough.

So balance size and memory and qvd loading will be the answer to your problem for slow loading.

[#3]

Hi Agnivesh,

You have the data 2Gb Qvds data.Is it from single qvd? or multiple?

and the way you have done the data modelling and scripting..how it has done..

Eventhough you've 2Gb Qvds , it will not take 1 hr whether it is badly modelled or Less RAM available than needed.

Give the exact info then we 'll try to help you out on these things..

Regards,

Koti