suggest-performance-fix

# Suggest Performance Fix

Identify performance issues and bottlenecks in code, suggesting specific optimizations.

## Performance Issue Categories

### 1. Algorithmic Complexity
- **Nested Loops**: O(n²) or worse time complexity
- **Inefficient Search**: Linear search when hash lookup possible
- **Redundant Calculations**: Computing same value multiple times
- **Inefficient Sorting**: Using bubble sort instead of quicksort/mergesort
- **String Concatenation**: Building strings in loops

### 2. Database Performance
- **N+1 Query Problem**: Loading related data in a loop
- **Missing Indexes**: Queries on unindexed columns
- **SELECT ***: Fetching unnecessary columns
- **No Query Pagination**: Loading all records at once
- **Missing Connection Pooling**: Creating new connection per query
- **Lack of Prepared Statements**: Re-parsing queries

### 3. Memory Issues
- **Memory Leaks**: Objects not released/garbage collected
- **Excessive Allocations**: Creating unnecessary objects
- **Large In-Memory Data**: Loading entire datasets into RAM
- **Caching Issues**: Not caching expensive operations
- **Deep Cloning**: Expensive deep copies when shallow would work

### 4. I/O Performance
- **Synchronous I/O**: Blocking operations in async context
- **No Batching**: Multiple small I/O operations instead of batch
- **Missing Compression**: Large payloads without compression
- **No Streaming**: Loading entire files into memory
- **Excessive File I/O**: Reading/writing files repeatedly

### 5. Frontend/API Performance
- **No Lazy Loading**: Loading all data upfront
- **Missing CDN**: Serving static assets from origin
- **Large Bundle Size**: Shipping unnecessary code
- **Render Blocking**: Blocking page render with scripts
- **Missing Caching Headers**: Not utilizing browser cache
- **Excessive API Calls**: Multiple calls when one would suffice

### 6. Concurrency Issues
- **Missing Parallelization**: Sequential when parallel possible
- **Race Conditions**: Unprotected shared stat