Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Reloadtime depends on your database ...How big your database is? i.e. How many rows, columns, size etc
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
remove unwanted fields
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
Your RowCount is big... consider working on QVD creation by Incremental Load...
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.
Use better configuration machines and optimize the way of extraction too.
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.