Explore

Find agent skills by outcome

10,338 skills indexed with the new KISS metadata standard.

Showing 24 of 10,338Categories: Communication, Education, Data, Coding & Debugging
Coding & Debugging
PromptBeginner5 minmarkdown

Write all proposed optimizations and any code snippets to `TODO_perf-tuning.md` only. Do not create any other files. If specific files should be created or edited

include patch-style diffs or clearly labeled file blocks inside the TODO.

0
Data
PromptBeginner5 minmarkdown

- **Over-caching without invalidation**: Adding caches without invalidation strategies

serving stale data and creating consistency bugs

0
Coding & Debugging
PromptBeginner5 minmarkdown

- **Synchronous blocking in async code**: Blocking the event loop or thread pool with synchronous operations

destroying concurrency benefits

0
Data
PromptBeginner5 minmarkdown

- **Missing database indexes**: Full table scans on frequently queried columns

causing query times to grow linearly with data volume

0
Data
PromptBeginner5 minmarkdown

- **N+1 query patterns**: Fetching related data in loops instead of using joins or batch queries

multiplying database round-trips linearly

0
Education
PromptBeginner5 minmarkdown

- Use EXPLAIN ANALYZE to inspect query execution plans and identify sequential scans

hash joins

0
Data
PromptBeginner5 minmarkdown

### Database (Query Analyzers

Index Tuning)

0
Coding & Debugging
PromptBeginner5 minmarkdown

- Use language-specific CPU and memory profilers (pprof for Go

py-spy for Python

0
Data
PromptBeginner5 minmarkdown

- Deploy Application Performance Monitoring (Datadog

New Relic

0
Data
PromptBeginner5 minmarkdown

- Use reproducible benchmarks with consistent hardware

data volume

0
Coding & Debugging
PromptBeginner5 minmarkdown

- [ ] API response times meet SLA: <200ms (p95) for standard endpoints

<50ms (p95) for database queries

0
Coding & Debugging
PromptBeginner5 minmarkdown

- Correlate bottlenecks with specific code paths

queries

0
Communication
PromptBeginner5 minmarkdown

- **Microservices**: gRPC for inter-service communication

message queues for decoupling

0
Coding & Debugging
PromptBeginner5 minmarkdown

- **API**: Payload size reduction

compression (gzip

0
Coding & Debugging
PromptBeginner5 minmarkdown

- **Frontend**: Code splitting

tree shaking

0
Coding & Debugging
PromptBeginner5 minmarkdown

- **Techniques**: Dynamic programming

memoization

0
Data
PromptBeginner5 minmarkdown

- **Data Structures**: Map vs Object for lookups

Set vs Array for uniqueness

0
Coding & Debugging
PromptBeginner5 minmarkdown

- Define performance budgets for critical paths (API response times

page load metrics

0
Data
PromptBeginner5 minmarkdown

- Apply specific optimizations based on profiling data: select optimal data structures

implement caching

0
Data
PromptBeginner5 minmarkdown

- Record reproducible benchmark conditions (hardware

data volume

0
Data
PromptBeginner5 minmarkdown

- Analyze database query patterns for N+1 problems

unnecessary joins

0
Data
PromptBeginner5 minmarkdown

- Collect database query execution plans to identify slow operations

missing indexes

0
Coding & Debugging
PromptBeginner5 minmarkdown

- **Accelerate frontend rendering** via code splitting

tree shaking

0
Coding & Debugging
PromptBeginner5 minmarkdown

Follow this systematic approach to deliver measurable

data-driven performance improvements while maintaining code quality and reliability.

0