Performance Review

When reviewing code for performance issues, check each category below. Reference the detailed checklist in references/performance-checklist.md.

Database & Queries

• N+1 query patterns (queries inside loops)
• Missing database indexes for frequently queried fields
• Unbounded queries without LIMIT/pagination
• SELECT * instead of selecting only needed columns
• Missing connection pooling

Memory & Resources

• Memory leaks: event listeners not removed, intervals not cleared, growing caches without bounds
• Large objects held in memory unnecessarily
• Unbounded arrays or maps that grow with usage
• Missing cleanup in component unmount/destroy lifecycle