performance-optimization

Fix N+1 queries in Rails by applying eager loading patterns like includes or preload to batch association queries. This Skill identifies where extra queries are triggered and generates a prioritized optimization plan to reduce database load.

Resolve Bullet gem warnings by analyzing the alerted endpoints and applying selective column loading or batching. This Skill interprets Bullet alerts and suggests targeted query refactoring to eliminate unnecessary database calls and improve response times.

rack-mini-profiler helps with Rails memory profiling by highlighting memory bloat during request cycles. This Skill integrates profiler data to pinpoint memory-heavy operations and proposes mitigations to reduce overall application memory consumption.

You need counter caches for Rails query optimization when frequently counting associated records without loading them into memory. This Skill identifies slow queries and recommends indexing or counter cache implementations to speed up data retrieval.

Yes, you can use this for memory management in Rails apps handling large datasets. It highlights memory bloat from complex associations and proposes batching or selective loading mitigations to keep response times fast under heavy data loads.

Rails endpoints might be slow despite indexes due to N+1 query patterns or memory bloat from loading unnecessary associations. This Skill analyzes your query performance to identify hidden bottlenecks and proposes targeted refactoring.