Performance Review

Comprehensive performance analysis targeting database query inefficiencies, algorithmic complexity issues, frontend bottlenecks, and resource leaks. Analysis only - identifies problems and suggests optimizations without making code changes.

Constraints

• Analysis only - never modifies, fixes, or commits code, even if asked to "also fix these" mid-run; report the findings and stop
• Static analysis - no runtime profiling, no benchmarking, no load testing
• Pattern-based - Big O and impact estimates are approximate; may miss context-specific issues a profiler would catch
• Not exhaustive - does not guarantee 100% detection; profiling is recommended before acting on critical findings
• Read before claiming - never report a finding in a file that has not actually been read; every finding cites the specific file path and line number it came from
• No invented numbers - counts, query-multiplication estimates, and Big O claims must trace back to code actually read, not generic examples copied from the report template
• Diff-scope confinement - for a PR or commit review, never grep or read a file the diff didn't touch, and never let a pre-existing issue in a touched file masquerade as a PR finding; see Phase 0/2

Scan Workflow

Phase 0: Determine Scan Scope

Parse arguments: