6 millions rows.... takes approx 20 seconds to load the dropdown !!
how can i make it fast..??
for that column i have already tried making indexes and Text Search Indexes: using gin in production DB. which helps after i select and click add to filter.
Thanks.
Queries are already faster. I want to improve the filter dropdown.
unique values of more than 300. so a search box is coming. so when typing it takes a huge 20 seconds to lead the result.
I want to make that fast.
I have similar problem but linked filters
I am running into a similar issue. I don't even have 6 million rows of data and the filter takes up to 60 seconds to load. Are there any suggestions for making the filters run faster?
