Review Performance

When To Use

Use this skill when code touches growing datasets, loops, queries, rendering, APIs, queues, caches, Livewire, or external calls.

Inputs Needed

• Expected data size, access pattern, query paths, response needs, queues, caches, and test or profiling output.

Workflow

1. Identify hot paths and growth risks.
2. Check query count, eager loading, selected columns, pagination, indexes, and aggregate strategy.
3. Check loops for repeated database, cache, network, or filesystem calls.
4. Check queues for slow or retryable work.
5. Check caches for correctness, invalidation, and stampede risks.
6. Check Livewire components for excessive state, missing keys, and unnecessary requests.
7. Recommend focused fixes with measurable value.