Right now, I'm reasonably confident that the autocomplete API on the admin management page is doing a table scan on the users table (should verify by asking the query planner). My hope is that adding an index can help avoid that, although I'm not sure how indices work for LIKE queries. More research possibly needed.
Right now, I'm reasonably confident that the autocomplete API on the admin management page is doing a table scan on the users table (should verify by asking the query planner). My hope is that adding an index can help avoid that, although I'm not sure how indices work for
LIKE
queries. More research possibly needed.