topic Re: Performance in QlikView

Performance

brindlogcool — Fri, 05 Jul 2013 19:23:22 GMT

Hi ,

I have gone through some developer checklist which has below points as not to be used as it will have impact in the performance. I would like to undertsand in more detail . Request to share the knowledge on this points

1.Set Analysis not used against large fact tables.

2.Pivot charts not used against large data sets.

3. Reduce the Number of variables in an Expression and also to target the expression repeatedly used.

4. Data Island Vs Varaibles. Data Island will be single threaded operation- I have not checked this but was eager to know about the data island.

Re: Performance

Gysbert_Wassenaar — Mon, 08 Jul 2013 08:08:41 GMT

You might want to read this discussion (if you haven't already).

Re: Performance

brindlogcool — Mon, 08 Jul 2013 12:59:47 GMT

Thanks Vikas and Gysbert, i have gone through the Qlikview Best practices and other post about the performance, but both of them doesnt have the points related to my Question

1.Set Analysis not used against large fact tables.

2.Pivot charts not used against large data sets.

3. Reduce the Number of variables in an Expression and also to target the expression repeatedly used.

4. Data Island Vs Varaibles. Data Island will be single threaded operation- I have not checked this but was eager to know about the data island.

Would like to know more on the above points.

Re: Performance

brindlogcool — Tue, 09 Jul 2013 22:11:38 GMT

Any inputs ?

Re: Performance

Anonymous — Mon, 29 Jul 2013 15:16:19 GMT

Hi, interesting post.

Besides the points listed by brindlogcool, I would be also interested to hear the experts' opinion regarding broken link in objects. E.g. a listbox that uses a field that is not in the data model.
I inherited an application that it's full of such objects. Though they are not displayed (conditionally hidden) and therefore QV should not be doing anything with them, I do wonder if their massive presence can somehow impact the overall performance of the app.

Thank you all!