Writing & Content
PromptBeginner5 minmarkdown
- Query optimization: rewrite queries using execution plan analysis
eliminate unnecessary subqueries and joins
0
Explore
Find agent skills by outcome
110,852 skills indexed with the new KISS metadata standard.
Showing 24 of 110,852Categories: Data & Insights, Cursor-rules, Data, General, Writing & Content, Coding & Debugging
General
PromptBeginner5 minmarkdown
- Indexing strategies: composite indexes
covering indexes
0
Coding & Debugging
PromptBeginner5 minmarkdown
- **Techniques**: Dynamic programming
memoization
0
General
PromptBeginner5 minmarkdown
- **Search**: Binary search
interpolation search
0
General
PromptBeginner5 minmarkdown
- **Sorting**: Quicksort
mergesort
0
General
PromptBeginner5 minmarkdown
- **String algorithms**: KMP
Rabin-Karp
0
Data
PromptBeginner5 minmarkdown
- **Data Structures**: Map vs Object for lookups
Set vs Array for uniqueness
0
General
PromptBeginner5 minmarkdown
- **Graph algorithms**: BFS
DFS
0
Coding & Debugging
PromptBeginner5 minmarkdown
- Define performance budgets for critical paths (API response times
page load metrics
0
General
PromptBeginner5 minmarkdown
- Validate that optimizations do not degrade performance in other areas (e.g.
memory for CPU trade-offs)
0
General
PromptBeginner5 minmarkdown
- Document all optimizations applied
their rationale
0
General
PromptBeginner5 minmarkdown
- Address scalability proactively by considering expected input growth
memory limitations
0
Data
PromptBeginner5 minmarkdown
- Apply specific optimizations based on profiling data: select optimal data structures
implement caching
0
General
PromptBeginner5 minmarkdown
- Review rendering cycles for layout thrashing
unnecessary re-renders
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
General
PromptBeginner5 minmarkdown
- Inspect memory allocation patterns for leaks
excessive garbage collection pauses
0
General
PromptBeginner5 minmarkdown
- Profile frontend performance using Chrome DevTools
Lighthouse
0
Data
PromptBeginner5 minmarkdown
- Collect database query execution plans to identify slow operations
missing indexes
0
General
PromptBeginner5 minmarkdown
- Capture baseline metrics: response time (p50
p95
0
General
PromptBeginner5 minmarkdown
- Identify bottlenecks using CPU profilers
memory profilers
0
Coding & Debugging
PromptBeginner5 minmarkdown
Follow this systematic approach to deliver measurable
data-driven performance improvements while maintaining code quality and reliability.
0
General
PromptBeginner5 minmarkdown
- **Enhance async and concurrency patterns** by optimizing event loops
worker threads
0
Data
PromptBeginner5 minmarkdown
- **Tune database query performance** by analyzing execution plans
eliminating N+1 problems
0