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,686 skills indexed with the new KISS metadata standard.
Showing 24 of 17,686Categories: Creative, Data, Writing & Content
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
Data
PromptBeginner5 minmarkdownQuality: 22
Database (Query Analyzers
Index Tuning)
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
Writing & Content
PromptBeginner5 minmarkdownQuality: 22
- Design cache-aside
write-through
0
Writing & Content
PromptBeginner5 minmarkdownQuality: 26
- Query optimization: rewrite queries using execution plan analysis
eliminate unnecessary subqueries and joins
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
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
Data
PromptBeginner5 minmarkdownQuality: 22
- Identify unnecessary copies of large data structures (pandas DataFrames
dicts)
0
Writing & Content
PromptBeginner5 minmarkdownQuality: 22
- Lock contention
race conditions
0
Data
PromptBeginner5 minmarkdownQuality: 22
- Loading full datasets instead of streaming
pagination
0
Data
PromptBeginner5 minmarkdownQuality: 22
- Review database queries for N+1 patterns
missing indexes
0
Writing & Content
PromptBeginner5 minmarkdownQuality: 22
- Check concurrency patterns for lock contention
serialized async work
0
Writing & Content
PromptBeginner5 minmarkdownQuality: 22
- Evaluate I/O operations for blocking calls
excessive reads/writes
0
Data
PromptBeginner5 minmarkdownQuality: 22
- Understand the expected traffic patterns
data volumes
0
Data
PromptBeginner5 minmarkdownQuality: 22
- Review available metrics
profiling data
0
Writing & Content
PromptBeginner5 minmarkdownQuality: 22
- Assess scalability under load including concurrency patterns
contention points
0
Data
PromptBeginner5 minmarkdownQuality: 22
- Analyze algorithmic complexity
data structure choices
0