Explore

Find agent skills by outcome

8,057 skills indexed with the new KISS metadata standard.

Showing 24 of 8,057Categories: Data, Coding & Debugging, Communication, Business
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
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
Business
PromptBeginner5 minmarkdown

- Measure user-perceived performance metrics that matter to the business

not synthetic micro-benchmarks

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
Business
PromptBeginner5 minmarkdown

- Connection management: connection pooling

read replicas

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