topic Re: Optimized way to Deploy Big qvw Files in QlikView

Optimized way to Deploy Big qvw Files

sujeetsingh — Fri, 03 Jul 2015 11:03:44 GMT

Hi everyone,

I am concerned to know the best way and minimum hardware configuration needed to deploy a QVW file of size 1TB or 500GB.

I came across many threads for this but not able to get the clear picture.

Below are the threads and are really helpful

Terabytes Scalability

Re: Large amount of data (120 million rows) ... anyone got experience?

My next question if from the point of developers. How to work with a file having 100 or 200 million records loaded in Qlik desktop.

Many time i tried to open a single table with few columns and 200 millions of rows and msg pops up "Out of Memory".

Well my local machine is 64 bit with 4GB RAM.

Thanks,

Re: Optimized way to Deploy Big qvw Files

alexandros17 — Fri, 03 Jul 2015 11:09:28 GMT

The problem is related to objects not only to processor and Ram (I think it's enough in your case)

Trying to load 200M rows in a table is not useful, limit the visualization and preset filters. Who looks as 200M rows?

Re: Optimized way to Deploy Big qvw Files

vardhancse — Fri, 03 Jul 2015 11:23:07 GMT

If there is such huge data, I think opening directly in server was preferable because local systems were not that much capable to open such huge dashboards

Re: Optimized way to Deploy Big qvw Files

sujeetsingh — Mon, 06 Jul 2015 04:18:53 GMT

As soon as reload is done with 200 million rows the document gives an error "Out of Memory" even not able to save it .

Re: Optimized way to Deploy Big qvw Files

sujeetsingh — Tue, 07 Jul 2015 07:08:12 GMT

That mean for verifying each time i need to deploy the files and cross check .

It seems crazy to me .

Re: Optimized way to Deploy Big qvw Files

vardhancse — Wed, 08 Jul 2015 03:28:35 GMT

Hi,

No need to publish, we can open the files from the server where we mount the folders and copy the qvw files to publish