Performance Review

Review code from a performance perspective.

Review Checklist

Database & Queries

• Check for N+1 query problems
• Verify proper use of indexes
• Look for unnecessary data fetching (SELECT *)
• Check batch operations vs individual queries
• Verify connection pool configuration

Memory & Resources

• Check for memory leaks (unclosed resources, retained references)
• Verify proper cleanup in lifecycle methods
• Look for unnecessary object creation in hot paths
• Check for unbounded collections or caches