Skip to content

Instantly share code, notes, and snippets.

View jonathanloos's full-sized avatar
✈️
Just cruising

Jonathan Loos jonathanloos

✈️
Just cruising
  • Harled Inc.
  • Waterloo, ON
View GitHub Profile
@jonathanloos
jonathanloos / LocalQueryPerformance.md
Last active February 25, 2022 04:47
Find a common list of queries we at Harled have used in our Ruby on Rails Platforms

Query Performance Monitoring

We've had the case where a seemingly small change in a query (such as adding a .join() clause) actually caused us a large load-related headache when run multiple times by our users in production. To avoid this issue in future iterations we now use (rack-mini-profiler)[https://github.com/MiniProfiler/rack-mini-profiler] to help us measure our queries in development! The profiler will give you a file-by-file, query-by-query analysis of your page load times and flag expensive queries.