Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So I have a massive in-memory table with about 142 million rows.
I am trying to use a List Box for one of the fields in this table.
Performance is really very very slow, so slow that the user thinks that the dashboard has hung up and is not working properly.
I tried using a Search Box, but the performance is even worse.
Any ideas on how to improve the performance of the List Box? I converted all numbers to text in that field already.
Well, as protrayed the data in hand seems to be huge so this is a known issue that as the data is huge the performance will be slow , few things to be done are:
1. Optimize your Data Model(There are lot of things that could be done here starting with dropping the unused fields , using autonumber for key fields, etc depending upon the kind of data in use)
2. Increase the RAM Space(in case its not capable of handling the data load)
3. Have a value selected in the app which is of higher hierarchical level than the list box in discussion, so that the data volume on the cache reduces and helps in better performance
Kevin, I have to agree with the other poster at the moment, by chance does your data model have synthetic tables and keys in it? If so, that would be the first thing to clean up to try to address the performance issues. Here is a direct Design Blog post regarding these that may be helpful:
https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634
If you want to search around for other posts in this are, here is the base URL, there are hundreds of how-to posts in this area...
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett