Skip to content

Reduce SQL timings in ProjectsController#show

The controller ProjectsController#show 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:

  • 121 000 requests per 12 hours
  • 17.5% of the request time is spent in SQL

SQL timings per request:

  • Mean: 102.45 ms
  • 95th percentile: 209.21 ms
  • 99th percentile: 278.26 ms

This controller should be improved so that the 99th percentile is consistently below 200 milliseconds, with an ideal target of 100 - 150 milliseconds.

Edited by Yorick Peterse