Data
PromptBeginner5 minmarkdownQuality: 26
- Missing database indexes: Full table scans on frequently queried columns
causing query times to grow linearly with data volume
0
Explore
Find agent skills by outcome
17,338 skills indexed with the new KISS metadata standard.
Showing 24 of 17,338Categories: Data, Coding & Debugging, Openclaw, Education
Data
PromptBeginner5 minmarkdownQuality: 26
- N+1 query patterns: Fetching related data in loops instead of using joins or batch queries
multiplying database round-trips linearly
0
Education
PromptBeginner5 minmarkdownQuality: 22
- Use EXPLAIN ANALYZE to inspect query execution plans and identify sequential scans
hash joins
0
Data
PromptBeginner5 minmarkdownQuality: 22
Database (Query Analyzers
Index Tuning)
0
Coding & Debugging
PromptBeginner5 minmarkdownQuality: 22
- Use language-specific CPU and memory profilers (pprof for Go
py-spy for Python
0
Data
PromptBeginner5 minmarkdownQuality: 22
- Deploy Application Performance Monitoring (Datadog
New Relic
0
Data
PromptBeginner5 minmarkdownQuality: 22
- Use reproducible benchmarks with consistent hardware
data volume
0
Coding & Debugging
PromptBeginner5 minmarkdownQuality: 26
- [ ] API response times meet SLA: <200ms (p95) for standard endpoints
<50ms (p95) for database queries
0
Coding & Debugging
PromptBeginner5 minmarkdownQuality: 22
- Correlate bottlenecks with specific code paths
queries
0
Coding & Debugging
PromptBeginner5 minmarkdownQuality: 22
- API: Payload size reduction
compression (gzip
0
Coding & Debugging
PromptBeginner5 minmarkdownQuality: 22
- Frontend: Code splitting
tree shaking
0
Coding & Debugging
PromptBeginner5 minmarkdownQuality: 22
- Techniques: Dynamic programming
memoization
0
Coding & Debugging
PromptBeginner5 minmarkdownQuality: 22
- Define performance budgets for critical paths (API response times
page load metrics
0
Data
PromptBeginner5 minmarkdownQuality: 22
- Data Structures: Map vs Object for lookups
Set vs Array for uniqueness
0
Data
PromptBeginner5 minmarkdownQuality: 26
- Apply specific optimizations based on profiling data: select optimal data structures
implement caching
0
Data
PromptBeginner5 minmarkdownQuality: 22
- Analyze database query patterns for N+1 problems
unnecessary joins
0
Data
PromptBeginner5 minmarkdownQuality: 22
- Record reproducible benchmark conditions (hardware
data volume
0
Data
PromptBeginner5 minmarkdownQuality: 22
- Collect database query execution plans to identify slow operations
missing indexes
0
Coding & Debugging
PromptBeginner5 minmarkdownQuality: 26
Follow this systematic approach to deliver measurable
data-driven performance improvements while maintaining code quality and reliability.
0
Coding & Debugging
PromptBeginner5 minmarkdownQuality: 22
- Accelerate frontend rendering via code splitting
tree shaking
0
Data
PromptBeginner5 minmarkdownQuality: 22
- Tune database query performance by analyzing execution plans
eliminating N+1 problems
0
Data
PromptBeginner5 minmarkdownQuality: 26
You are a senior performance optimization expert and specialist in systematic analysis and measurabl...
database queries
0
Coding & Debugging
PromptBeginner5 minmarkdownQuality: 26
RULE: When using this prompt
you must create a file named TODO_optimization-auditor.md. This file must contain the findings resulting from this research as checkable checkboxes that can be coded and tracked by an LLM.,TRUE,TEXT.....
0
Coding & Debugging
PromptBeginner5 minmarkdownQuality: 22
- Evidence: Specific code path
pattern
0