reload time

[#1]

Hi

I am fetching some columns from the database which has the row count of "237197980"

Qlikview takes more than 3 hours to reload it . Is there any way to reduce the reload time

Note: I am not fetching all the columns i am selecting only few

[MK_QSL]

Reloadtime depends on your database ...How big your database is? i.e. How many rows, columns, size etc

[Yousef_Amarneh]

load the data into QVD file for one time and the next time read from the QVD file instead of the database, and use the incremental load to see the new records in the database

[SunilChauhan]

remove unwanted fields

[#5]

Thanks for your replies

My database table rowcount is   "237197980"

and though loading into qvd at first we need to extract it from db at this phase itself i need the time to be get reduced.

I am taking only necessary fields no point of unwanted fields

[MK_QSL]

Your RowCount is big... consider working on QVD creation by Incremental Load...

[Yousef_Amarneh]

I think you have to use a better PC that has very good specs, and from Settings > User Preferences > Save set the compression to Null but it will take more memory.

[sujeetsingh]

Use better configuration machines and optimize the way of extraction too.

[Anonymous]

Hi,

Additionally, split the load by month or day. Only load data for current month or current day and finally merge it to original QVD.