Data
PromptBeginner5 minmarkdownQuality: 24
- Collect database query execution plans to identify slow operations
missing indexes
0
Explore
Find agent skills by outcome
9,957 skills indexed with the new KISS metadata standard.
Showing 24 of 9,957Categories: Data & Insights, Cursor-rules, Data, Writing & Content
Data
PromptBeginner5 minmarkdownQuality: 24
- **Tune database query performance** by analyzing execution plans
eliminating N+1 problems
0
Data
PromptBeginner5 minmarkdownQuality: 28
You are a senior performance optimization expert and specialist in systematic analysis and measurable improvement of algorithm efficiency
database queries
0
Data
PromptBeginner5 minmarkdownQuality: 24
- Identify unnecessary copies of large data structures (pandas DataFrames
dicts)
0
Writing & Content
PromptBeginner5 minmarkdownQuality: 24
- Lock contention
race conditions
0
Data
PromptBeginner5 minmarkdownQuality: 24
- Loading full datasets instead of streaming
pagination
0
Writing & Content
PromptBeginner5 minmarkdownQuality: 24
- Check concurrency patterns for lock contention
serialized async work
0
Data
PromptBeginner5 minmarkdownQuality: 24
- Review database queries for N+1 patterns
missing indexes
0
Writing & Content
PromptBeginner5 minmarkdownQuality: 24
- Evaluate I/O operations for blocking calls
excessive reads/writes
0
Data
PromptBeginner5 minmarkdownQuality: 24
- Review available metrics
profiling data
0
Data
PromptBeginner5 minmarkdownQuality: 24
- Understand the expected traffic patterns
data volumes
0
Writing & Content
PromptBeginner5 minmarkdownQuality: 24
- **Assess** scalability under load including concurrency patterns
contention points
0
Data
PromptBeginner5 minmarkdownQuality: 24
- **Analyze** algorithmic complexity
data structure choices
0
Writing & Content
PromptBeginner5 minmarkdownQuality: 24
- Data access patterns
read/write ratios
0
Data
PromptBeginner5 minmarkdownQuality: 24
- Leverage Redis data structures (Sorted Sets
HyperLogLog
0
Data
PromptBeginner5 minmarkdownQuality: 24
- Avoid embedding volatile data (timestamps
random values) in keys that should be shared
0
Data
PromptBeginner5 minmarkdownQuality: 24
- Set TTLs based on data change frequency: seconds for real-time data
minutes for session data
0
Data
PromptBeginner5 minmarkdownQuality: 24
- [ ] Cache hit rates meet target thresholds (typically >90% for hot data
>70% for warm data)
0
Data
PromptBeginner5 minmarkdownQuality: 24
- [ ] Memory sizing accounts for peak load
data growth
0
Writing & Content
PromptBeginner5 minmarkdownQuality: 24
- Map each data entity to its invalidation strategy (write-through
write-behind
0
Data
PromptBeginner5 minmarkdownQuality: 28
- **Event-driven invalidation**: Publish cache invalidation events on data changes
scalable for distributed systems
0
Writing & Content
PromptBeginner5 minmarkdownQuality: 24
- **Write-through**: Synchronous cache update on every write
strong consistency
0
Writing & Content
PromptBeginner5 minmarkdownQuality: 28
- **Cache-aside (lazy loading)**: Application manages cache reads and writes explicitly
simple but risk of stale reads
0
Writing & Content
PromptBeginner5 minmarkdownQuality: 24
- **Write-behind (write-back)**: Asynchronous batch writes to backing store
lower write latency
0