Reduce SQL timings in AutocompleteController#users.json
The controller AutocompleteController#users.json
is one of our most frequently requested controllers with a 99th percentile (of SQL query timings) above 200 milliseconds. According to our daily overview the statistics are as follows:
- 40 000 requests per 12 hours
- 98.7% of the request time is spent in SQL
SQL timings per request:
- Mean: 626.60 ms
- 95th percentile: 4.86 s
- 99th percentile: 5.75 s
This controller should be improved so that the 99th percentile is consistently below 200 milliseconds, with an ideal target of 100 - 150 milliseconds.