Hi Arvin. From looking at your perf recording, it appears you're going through sqlproxy (aka dataserver). Are you connecting up to an extract or a live connection? If live, do you have a proper index on the field you're trying to filter? What is the cardinality of the field you're trying to add with the filter?
Data loaded into Hyper via Tab Prep - so extract no db. its a very high cardinatlity maybe 1000. Thats the new addition to our page that results in this if I remove this filter i get very fast results.
I did not think we could do anything to the data engine in terms of index, how can i tell Hyper to index that table or optimize it further
1000 unique values while a lot, doesn't seem overly excessive unless the length of the value is really long. What if you change the quick filter type to a text box instead of drop down, does this help at all? Also, Hyper should automatically index / optimize so there's not much to be done here. Are you able to attach your workbook by chance? One other thought is to try and add a context filter on the ones that are quick performing, you can just right click and set this within the filter shelf. Also, turn off "show only relevant values" for the quick filter setting and see if this helps.