queue icon indicating copy to clipboard operation
queue copied to clipboard

Add index to netid column in users table

Open nwalters512 opened this issue 6 years ago • 0 comments

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.

nwalters512 avatar May 14 '19 23:05 nwalters512