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
Explore
Find agent skills by outcome
15,749 skills indexed with the new KISS metadata standard.
Showing 24 of 15,749Categories: Communication, Coding & Debugging, Business, Data
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
- Analyze database query patterns for N+1 problems
unnecessary joins
0
Data
PromptBeginner5 minmarkdown
- Record reproducible benchmark conditions (hardware
data volume
0
Data
PromptBeginner5 minmarkdown
- Collect database query execution plans to identify slow operations
missing indexes
0
Coding & Debugging
PromptBeginner5 minmarkdown
Follow this systematic approach to deliver measurable
data-driven performance improvements while maintaining code quality and reliability.
0
Coding & Debugging
PromptBeginner5 minmarkdown
- **Accelerate frontend rendering** via code splitting
tree shaking
0
Business
PromptBeginner5 minmarkdown
- **Improve memory management** through heap profiling
leak detection
0
Data
PromptBeginner5 minmarkdown
- **Tune database query performance** by analyzing execution plans
eliminating N+1 problems
0
Data
PromptBeginner5 minmarkdown
You are a senior performance optimization expert and specialist in systematic analysis and measurable improvement of algorithm efficiency
database queries
0