# ruby-on-rails
2 posts tagged with "ruby-on-rails"
I Had No Idea Rails Could Query the Database in Parallel
Rails can run independent database queries in parallel with `load_async` and the `async_*` aggregation helpers, turning a sequential stack of dashboard queries into concurrent ones. This post covers what it does, the thread-pool and connection-pool configuration it needs, and when *not* to reach for it. Basically: "I thought Rails ran my queries one at a time — turns out it'll run them all at once if you ask."
Making Indexes Work For You: Composite Indexes and Query Plans (Part 2)
Part 2 is about the practical side of indexes — the strategy behind using them well. It covers composite indexes and the leftmost prefix rule (the column order genuinely matters, and the first column can do double duty), how to use EXPLAIN to stop guessing whether your index is actually being used, the situations where indexing is the wrong call (small tables, low cardinality, write-heavy tables), and a production gotcha I learned the hard way: adding an index to a huge table isn't a casual operation and needs `algorithm: :concurrently` to avoid locking everything. Basically: "I knew indexes make queries faster — here's everything I didn't know about using them well."