Cache/speed up large select options array

I have a select where the user searches through the database and chooses from a list of 144000 cities, and usually the query takes around 2 seconds or so for a Select field query. Is there a way/any recommendations on how I could speed this up?

awcodes•5/12/23, 3:45 PM

have you indexed the db column?

cioriciOP•5/12/23, 7:38 PM

Which one? Can you please explain this a bit more?

cioriciOP•5/12/23, 7:45 PM

Actually yes, sorry... I added the name of the city as an index, but I just found that there is a 1000ms debounce setting for the selects which only trigger the search after 1s, the query and result take les than 300ms.

Kenneth Sese•5/12/23, 8:30 PM

You can change the debounce on the select using ->searchDebounce()->searchDebounce() and then whatever number. I use 200

KKenneth Sese You can change the debounce on the select using `->searchDebounce()` and then wh...

cioriciOP•5/15/23, 7:01 AM

Excellent, thank you!

Cache/speed up large select options array

Similar Threads

Similar Threads

Similar Threads