Writing & Content
PromptBeginner5 minmarkdown
- Design cache-aside
write-through
0
Explore
Find agent skills by outcome
15,831 skills indexed with the new KISS metadata standard.
Showing 24 of 15,831Categories: Writing & Content, Data, Creative
Writing & Content
PromptBeginner5 minmarkdown
- Query optimization: rewrite queries using execution plan analysis
eliminate unnecessary subqueries and joins
0
Data
PromptBeginner5 minmarkdown
- **Data Structures**: Map vs Object for lookups
Set vs Array for uniqueness
0
Data
PromptBeginner5 minmarkdown
- Apply specific optimizations based on profiling data: select optimal data structures
implement caching
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
Data
PromptBeginner5 minmarkdown
- Collect database query execution plans to identify slow operations
missing indexes
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
Data
PromptBeginner5 minmarkdown
- Identify unnecessary copies of large data structures (pandas DataFrames
dicts)
0
Writing & Content
PromptBeginner5 minmarkdown
- Lock contention
race conditions
0
Data
PromptBeginner5 minmarkdown
- Loading full datasets instead of streaming
pagination
0
Writing & Content
PromptBeginner5 minmarkdown
- Check concurrency patterns for lock contention
serialized async work
0
Data
PromptBeginner5 minmarkdown
- Understand the expected traffic patterns
data volumes
0
Writing & Content
PromptBeginner5 minmarkdown
- Evaluate I/O operations for blocking calls
excessive reads/writes
0
Data
PromptBeginner5 minmarkdown
- Review database queries for N+1 patterns
missing indexes
0
Data
PromptBeginner5 minmarkdown
- Review available metrics
profiling data
0
Data
PromptBeginner5 minmarkdown
- **Analyze** algorithmic complexity
data structure choices
0
Writing & Content
PromptBeginner5 minmarkdown
- **Assess** scalability under load including concurrency patterns
contention points
0
Creative
PromptBeginner5 minmarkdown
- Plans for failure modes including stampede
cold start
0
Writing & Content
PromptBeginner5 minmarkdown
- Data access patterns
read/write ratios
0
Data
PromptBeginner5 minmarkdown
- Leverage Redis data structures (Sorted Sets
HyperLogLog
0
Data
PromptBeginner5 minmarkdown
- Set TTLs based on data change frequency: seconds for real-time data
minutes for session data
0
Data
PromptBeginner5 minmarkdown
- Avoid embedding volatile data (timestamps
random values) in keys that should be shared
0