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.
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.
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.
