Best way to learn query optimization?

• bullet

  11 6,768 8.5 Ruby

  help to kill N+1 queries and unused eager loading

  You could add the bullet gem to your project. It can notify you (in a variety of ways) if your queries can be optimised.

• Rails PG Extras

  4 931 6.6 Ruby

  Rails PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.

  https://github.com/pawurb/rails-pg-extras is useful for identifying slow queries and generally things that could make queries slow.

• SonarQube

  www.sonarqube.org

  sponsored

  Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.

  

Suggest a related project