performance-optimization-skill

What I do

I help you identify and resolve performance bottlenecks across the full stack:

1. Profiling: CPU, memory, and I/O profiling for Python and Node.js
2. Caching: Redis, memoization, HTTP caching, and CDN strategies
3. Bundle Optimization: JavaScript bundle analysis and reduction
4. Lazy Loading: Code splitting and on-demand resource loading
5. Database Query Optimization: N+1 detection, query analysis, indexing
6. Memory Leaks: Detection and resolution patterns

When to use me

Use this skill when:

• Investigating slow API responses or page loads
• Setting up caching layers (Redis, memoization)
• Analyzing and reducing JavaScript bundle size
• Detecting and fixing N+1 query problems
• Profiling CPU or memory usage
• Implementing lazy loading or code splitting
• Optimizing database query performance
• Diagnosing memory leaks in long-running processes

Related Skills

• database-migration-skill: Handles schema lifecycle (creating indexes in migrations). This skill handles runtime query optimization and profiling.
• frontend-design-skill: UI creation. This skill handles rendering performance optimization.
• docker-containerization-skill: Container resource limits and configuration.

---

Step 1: Profiling

Python (cProfile)

python -m cProfile -s cumtime app.py
python -m cProfile -o profile.stats app.py

import cProfile
import pstats

def profile_function(func, *args):
    profiler = cProfile.Profile()
    result = profiler.runcall(func, *args)
    stats = pstats.Stats(profiler)
    stats.sort_stats('cumulative')
    stats.print_stats(20)
    return result

Python (line_profiler)

from line_profiler import profile

@profile
def slow_function(data):
    result = []
    for item in data:
        processed = expensive_operation(item)
        result.append(processed)
    return result

Node.js

node --prof app.js
node --prof-process isolate-*.log > profile.txt

NODE_OPTIONS="--inspect" node app.js
# Open chrome://inspect → CPU Profile