Need Ideas for reduce Extracting time

[sathishkumar_go]

Hi All,

I have 3 years data. Scheduler runs daily wise.every time qlikview read all the data. so qlikview takes more time for extracting.

what is the best solution for this? I need to reduce the extracting time?I already tried incremental load and its working fine.( now i am thinking without incremental load) what are all the possible solutions?

-Sathish

[#2]

Is it possible for you to do some pre-aggregation in your data source?

Does your historical data change? Maybe you could do some aggregation of your historical data and store it in QVD-files.

[sathishkumar_go]

Hi Vegar,

Thanks for ur reply.

if i go Historical data, suppose client update the last year data or last 2 year data? that time it will not reflect.

I want dynamic. every time enduser don't want to reload manually.

-Sathish