prosopite
:mag: Rails N+1 queries auto-detection with zero false positives / false negatives (by charkost)
bullet
help to kill N+1 queries and unused eager loading (by flyerhzm)
Our great sponsors
| prosopite | bullet | |
|---|---|---|
| 19 | 27 | |
| 1,430 | 6,983 | |
| - | - | |
| 7.2 | 7.7 | |
| 3 months ago | 3 months ago | |
| Ruby | Ruby | |
| Apache License 2.0 | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
prosopite
Posts with mentions or reviews of prosopite.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-06-21.
-
Prosopite is now able to ignore low priority N+1 queries with few repetitions
The new option is called Prosopite.min_n_queries: https://github.com/charkost/prosopite
-
What are the main suspects in a really slow Rails app?
N+1 requests are an easy first step. Bullet gem works, but is overeager. I prefer Prosopite for this task (https://github.com/charkost/prosopite)
-
Prosopite gem a year after its release hits 785 stars! Thanks!
I first posted prosopite in this subreddit a year ago as an alternative to bullet.
- Rails N+1 queries auto-detection with zero false positives / false negatives
-
Tools to help you detect n+1 queries
A recent n+1 tool is Prospite. It was released a couple of weeks ago so it's not been written about it ...
- N+1 queries auto-detection with zero false positives / false negatives
- New N+1 queries auto-detector for Rails is trending on GitHub
- My new Rails N+1 auto-detector is trending on GitHub!
bullet
Posts with mentions or reviews of bullet.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-04-18.
- What was the name of the gem that finds all unindexed foreign keys?
-
Ban 1+N in Django
Rails has Bullet[0] to help identify and warn you against N+1
Does Django have anything active? Quick search revealed nplusone[1] but its been dead since 2018.
-
Inherited rails app - what the hell are all these rack timeout lines in the log?
Without seeing more of the app, it's tough to say for certain, but one gem you might find helpful is the [bullet](https://github.com/flyerhzm/bullet) gem -- set this up in the app then start browsing around the app in development. If you have any N+1 queries or other minor optimizations that could be done it will inform you about them.
-
A Guide to Memoization in Ruby
Getting rid of N+1 queries - This can help improve the speed of an app. The Bullet or Prosopite gems can give a lending hand here. The N+1 Dilemma — Bullet or Prosopite? entails a brief comparison of both.
-
Understanding N and 1 queries problem
There's a Ruby gem called Bullet that identifies and warns developers about N+1 problems. You can also have it fail tests if detected.
I don't know if the approach is possible with every ORM or if it's just leveraging some Ruby perks, but I can't think of a good reason why you wouldn't use the equivalent everywhere.
-
Help with N+1 problem.
You might consider adding the bullet gem as a development requirement and see what it tells you, it's generally pretty good at spotting n-queries and letting you know how to fix them.
-
Understanding and Fixing N+1 Query
As a Rails developer, recently I found Bullet [0] which helps massively in dealing with eager loading. For some reason I expected the framework to manage this sort of thing for me, even when Rails actually does a ton out of the box already. Only while refactoring I picked up on queries dragging performance. Oh well...
-
How do you find the cause of slowness in your app?
This is good advice, it'll likely pick out some glaring issues right away. I would generally recommend looking at DB queries here too and recommend Bullet, but most software like DataDog, AppSignal etc will often also point N+1 and issues like it out.
-
Yet Another Post About N + 1 Queries
In order to find all those N + 1 queries that are slowing down in your application, the community recommends using the Bullet gem.
- What are the main suspects in a really slow Rails app?
What are some alternatives?
When comparing prosopite and bullet you can also consider the following projects:
Peek - Take a peek into your Rails applications.
rack-mini-profiler - Profiler for your development and production Ruby rack apps.
MemoryProfiler - memory_profiler for ruby
ruby-prof - A ruby profiler. See https://ruby-prof.github.io for more information.
Derailed Benchmarks - Go faster, off the Rails - Benchmarks for your whole Rails app
Timeasure - Transparent method-level wrapper for profiling purposes in Ruby
benchmark-ips - Provides iteration per second benchmarking for Ruby
active_record_doctor - Identify database issues before they hit production.