Data
PromptBeginner5 minmarkdownQuality: 28
- Over-caching without invalidation: Adding caches without invalidation strategies
serving stale data and creating consistency bugs
0
Explore
Find agent skills by outcome
133,209 skills indexed with the new KISS metadata standard.
Showing 24 of 133,209Categories: Data & Insights, Data, Education, Coding & Debugging, General
General
PromptBeginner5 minmarkdownQuality: 28
- Memory leaks under load: Allocations growing without bound in long-running processes
leading to OOM crashes in production
0
Coding & Debugging
PromptBeginner5 minmarkdownQuality: 28
- Synchronous blocking in async code: Blocking the event loop or thread pool with synchronous operat...
destroying concurrency benefits
0
Data
PromptBeginner5 minmarkdownQuality: 28
- Missing database indexes: Full table scans on frequently queried columns
causing query times to grow linearly with data volume
0
General
PromptBeginner5 minmarkdownQuality: 24
- Monitor slow query logs and set appropriate thresholds (e.g.
50ms for OLTP queries)
0
Data
PromptBeginner5 minmarkdownQuality: 28
- 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: 24
- Use EXPLAIN ANALYZE to inspect query execution plans and identify sequential scans
hash joins
0
General
PromptBeginner5 minmarkdownQuality: 24
- Implement distributed tracing (Jaeger
Zipkin) to identify cross-service latency bottlenecks
0
Data
PromptBeginner5 minmarkdownQuality: 24
Database (Query Analyzers
Index Tuning)
0
General
PromptBeginner5 minmarkdownQuality: 24
- Run load tests with k6
JMeter
0
Coding & Debugging
PromptBeginner5 minmarkdownQuality: 24
- Use language-specific CPU and memory profilers (pprof for Go
py-spy for Python
0
General
PromptBeginner5 minmarkdownQuality: 24
Backend (APM
Profilers
0
Data
PromptBeginner5 minmarkdownQuality: 24
- Deploy Application Performance Monitoring (Datadog
New Relic
0
General
PromptBeginner5 minmarkdownQuality: 24
Frontend (Chrome DevTools
Lighthouse
0
General
PromptBeginner5 minmarkdownQuality: 24
- Address scalability: proactively consider expected input size
memory limitations
0
General
PromptBeginner5 minmarkdownQuality: 28
- Provide alternative solutions when trade-offs exist (in-place vs additional memory
speed vs memory)
0
General
PromptBeginner5 minmarkdownQuality: 24
- Identify constraints
input/output requirements
0
General
PromptBeginner5 minmarkdownQuality: 28
- Remember that premature optimization is counterproductive
but strategic optimization is essential
0
General
PromptBeginner5 minmarkdownQuality: 24
- Capture percentiles (p50
p95
0
General
PromptBeginner5 minmarkdownQuality: 24
- Consider the full system impact of optimizations
not just local improvements
0
General
PromptBeginner5 minmarkdownQuality: 24
- [ ] All optimizations are documented with rationale
measured impact
0
Data
PromptBeginner5 minmarkdownQuality: 24
- Use reproducible benchmarks with consistent hardware
data volume
0
Coding & Debugging
PromptBeginner5 minmarkdownQuality: 28
- [ ] API response times meet SLA: <200ms (p95) for standard endpoints
<50ms (p95) for database queries
0
General
PromptBeginner5 minmarkdownQuality: 24
- Document trade-offs: readability vs performance
memory vs CPU
0