Data
PromptBeginner5 minmarkdownQuality: 22
- Analyze database query patterns for N+1 problems
unnecessary joins
0
Explore
Find agent skills by outcome
9,385 skills indexed with the new KISS metadata standard.
Showing 24 of 9,385Categories: Data & Insights, Productivity, Data
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
Productivity
PromptBeginner5 minmarkdownQuality: 22
- Assign each task a stable ID (e.g.
TASK-1.1) and use checklist items in outputs.
0
Data
PromptBeginner5 minmarkdownQuality: 26
You are a senior performance optimization expert and specialist in systematic analysis and measurable improvement of algorithm efficiency
database queries
0
Productivity
PromptBeginner5 minmarkdownQuality: 22
- Treat every requirement below as an explicit
trackable task.
0
Data
PromptBeginner5 minmarkdownQuality: 22
- Identify unnecessary copies of large data structures (pandas DataFrames
dicts)
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
Data
PromptBeginner5 minmarkdownQuality: 22
- Understand the expected traffic patterns
data volumes
0
Data
PromptBeginner5 minmarkdownQuality: 22
- Review available metrics
profiling data
0
Data
PromptBeginner5 minmarkdownQuality: 22
- **Analyze** algorithmic complexity
data structure choices
0
Productivity
PromptBeginner5 minmarkdownQuality: 22
- Assign each task a stable ID (e.g.
TASK-1.1) and use checklist items in outputs.
0
Productivity
PromptBeginner5 minmarkdownQuality: 22
- Treat every requirement below as an explicit
trackable task.
0
Data
PromptBeginner5 minmarkdownQuality: 22
- Leverage Redis data structures (Sorted Sets
HyperLogLog
0
Data
PromptBeginner5 minmarkdownQuality: 22
- Set TTLs based on data change frequency: seconds for real-time data
minutes for session data
0
Data
PromptBeginner5 minmarkdownQuality: 22
- Avoid embedding volatile data (timestamps
random values) in keys that should be shared
0
Data
PromptBeginner5 minmarkdownQuality: 22
- [ ] Cache hit rates meet target thresholds (typically >90% for hot data
>70% for warm data)
0
Data
PromptBeginner5 minmarkdownQuality: 22
- [ ] Memory sizing accounts for peak load
data growth
0
Data
PromptBeginner5 minmarkdownQuality: 26
- **Event-driven invalidation**: Publish cache invalidation events on data changes
scalable for distributed systems
0
Data
PromptBeginner5 minmarkdownQuality: 26
- **Distributed caching**: Redis clusters for shared state
Memcached for simple key-value hot data
0
Data
PromptBeginner5 minmarkdownQuality: 22
- **Database caching**: Query result caching
materialized views
0
Data
PromptBeginner5 minmarkdownQuality: 22
- Calculate cache memory requirements based on data size
cardinality
0