topic Re: How does In Memory Works in Qlikview? in QlikView

How does In Memory Works in Qlikview?

Wed, 20 Jul 2016 16:46:43 GMT

Hi,

I am having problems with the processing time.

the move to a tab operation is effected in all the data, which takes on average 20 seconds without applying any filter time, over a period of 3 years with 1 million rows.

my question is that by restricting the filter to 30 days in a specific year, takes the same amount of time.

QV will always covers all fields?

should not be as ralacionales data base, applying a WHERE operations are not performed with the indicated results and do not compared with other rows

PD: my date field is ordered.

Re: How does In Memory Works in Qlikview?

Clever_Anjos — Wed, 20 Jul 2016 17:05:28 GMT

It depends of many aspects

You expressions
How your data is related
What´s the frequency of your data.

It would be easier if you post a sample of your APP

Re: How does In Memory Works in Qlikview?

rwunderlich — Wed, 20 Jul 2016 22:52:09 GMT

A smaller amount of selected data should take less time to process. So my guess is you have an improperly written expression or are doing something with a data island. Can you post your app, or at least the chart expressions?

-Rob