topic Re: reload time in QlikView

reload time

Thu, 31 Jul 2014 09:34:46 GMT

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

Re: reload time

MK_QSL — Thu, 31 Jul 2014 09:38:00 GMT

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

Re: reload time

Yousef_Amarneh — Thu, 31 Jul 2014 09:38:16 GMT

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

Re: reload time

SunilChauhan — Thu, 31 Jul 2014 09:40:58 GMT

remove unwanted fields

Re: reload time

Thu, 31 Jul 2014 09:49:48 GMT

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

Re: reload time

MK_QSL — Thu, 31 Jul 2014 09:58:08 GMT

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

Re: reload time

Yousef_Amarneh — Thu, 31 Jul 2014 09:59:38 GMT

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.

Re: reload time

sujeetsingh — Thu, 31 Jul 2014 10:23:40 GMT

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

Re: reload time

Anonymous — Thu, 31 Jul 2014 10:30:32 GMT

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.