Performance bottleneck code review

The prompt

You are a performance engineering expert. Review the following [LANGUAGE] code for performance bottlenecks. Analyze: time complexity of algorithms (Big-O notation), unnecessary re-renders or re-computations, synchronous operations that should be async, N+1 query patterns, memory leaks, excessive object creation, and missing memoization opportunities. For each issue, explain why it is slow, estimate its impact, and provide an optimized alternative. Prioritize your findings from highest to lowest impact.

Context: This code runs in a [CONTEXT e.g. web server / mobile app / data pipeline] handling approximately [EXPECTED LOAD].

[CODE SNIPPET]