topic Regarding data size loading?? in QlikView

Regarding data size loading??

sushil353 — Mon, 02 May 2011 12:12:57 GMT

Hi exerts..

I am working on qlikview POC.... We have a fact table in which for every hour there is approximate 100 million row of data is feeded... I am working on a personal(trial) version of qlikview..... It is loading 1 million of records in 1 hour.. on my machine fatching data from oracle db....

can you please tell me which product of qlikview can handle this kind of situation where in every hour the data size and records are huge...

Is the server/publisher addition of qlikview able to handle it??

Thanks in advance

Regarding data size loading??

erichshiino — Mon, 02 May 2011 12:37:19 GMT

If you use QV 10 you can have better performance due to concurrent loading tasks.

To go further, I don't think you can get another product.

You may need better hardware or a incremental reload approach ( to get only the new records - maybe you already considered that).

Regarding data size loading??

sushil353 — Mon, 02 May 2011 12:47:23 GMT

Hi shinu..

As i am using only the trial version..Is the server or publisher version can do fast loading as compare to this trial version

Regarding data size loading??

Mon, 02 May 2011 13:50:29 GMT

You won't gain anything new regarding performance by getting the Server or Publisher. This is used to automate and administer tasks regarding QV documents.

As Erich says, you might want to look into better hardware and/or incremental reloads to ease the burden.