Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
sujeetsingh
Master III
Master III

Optimized way to Deploy Big qvw Files

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,

SK

5 Replies
alexandros17

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?

vardhancse
Specialist III
Specialist III

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

sujeetsingh
Master III
Master III
Author

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

sujeetsingh
Master III
Master III
Author

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

It seems crazy to me .

vardhancse
Specialist III
Specialist III

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