Education
PromptBeginner5 minmarkdown
- Use EXPLAIN ANALYZE to inspect query execution plans and identify sequential scans
hash joins
1
Explore
Find agent skills by outcome
116,064 skills indexed with the new KISS metadata standard.
Showing 24 of 116,064Categories: General, Cursor-rules, Coding & Debugging, Education
General
PromptBeginner5 minmarkdown
- Implement distributed tracing (Jaeger
Zipkin) to identify cross-service latency bottlenecks
0
General
PromptBeginner5 minmarkdown
- Run load tests with k6
JMeter
0
Coding & Debugging
PromptBeginner5 minmarkdown
- Use language-specific CPU and memory profilers (pprof for Go
py-spy for Python
0
General
PromptBeginner5 minmarkdown
### Frontend (Chrome DevTools
Lighthouse
0
General
PromptBeginner5 minmarkdown
### Backend (APM
Profilers
0
General
PromptBeginner5 minmarkdown
- Address scalability: proactively consider expected input size
memory limitations
0
General
PromptBeginner5 minmarkdown
- Provide alternative solutions when trade-offs exist (in-place vs additional memory
speed vs memory)
0
General
PromptBeginner5 minmarkdown
- Identify constraints
input/output requirements
0
General
PromptBeginner5 minmarkdown
- Remember that premature optimization is counterproductive
but strategic optimization is essential
0
General
PromptBeginner5 minmarkdown
- Capture percentiles (p50
p95
0
General
PromptBeginner5 minmarkdown
- Consider the full system impact of optimizations
not just local improvements
0
General
PromptBeginner5 minmarkdown
- [ ] All optimizations are documented with rationale
measured impact
0
General
PromptBeginner5 minmarkdown
- [ ] Frontend metrics meet targets: LCP <2.5s
FID <100ms
0
Coding & Debugging
PromptBeginner5 minmarkdown
- [ ] API response times meet SLA: <200ms (p95) for standard endpoints
<50ms (p95) for database queries
0
General
PromptBeginner5 minmarkdown
After completing optimization
verify:
0
General
PromptBeginner5 minmarkdown
- Document trade-offs: readability vs performance
memory vs CPU
0
General
PromptBeginner5 minmarkdown
- Implement optimizations incrementally
measuring after each change
0
Coding & Debugging
PromptBeginner5 minmarkdown
- Correlate bottlenecks with specific code paths
queries
0
General
PromptBeginner5 minmarkdown
- Profile memory usage including heap size
GC frequency
0
General
PromptBeginner5 minmarkdown
- Classify each bottleneck by type: CPU-bound
I/O-bound
0
General
PromptBeginner5 minmarkdown
- Capture response time percentiles (p50
p95
0
Coding & Debugging
PromptBeginner5 minmarkdown
- **API**: Payload size reduction
compression (gzip
0
Coding & Debugging
PromptBeginner5 minmarkdown
- **Frontend**: Code splitting
tree shaking
0