Data
PromptBeginner5 minmarkdownQuality: 24
- Tune database query performance by analyzing execution plans
eliminating N+1 problems
0
Explore
Find agent skills by outcome
14,613 skills indexed with the new KISS metadata standard.
Showing 24 of 14,613Categories: Communication, Data, Creative
Data
PromptBeginner5 minmarkdownQuality: 28
You are a senior performance optimization expert and specialist in systematic analysis and measurabl...
database queries
0
Data
PromptBeginner5 minmarkdownQuality: 24
- Identify unnecessary copies of large data structures (pandas DataFrames
dicts)
0
Data
PromptBeginner5 minmarkdownQuality: 24
- Loading full datasets instead of streaming
pagination
0
Data
PromptBeginner5 minmarkdownQuality: 24
- Review database queries for N+1 patterns
missing indexes
0
Data
PromptBeginner5 minmarkdownQuality: 24
- Understand the expected traffic patterns
data volumes
0
Data
PromptBeginner5 minmarkdownQuality: 24
- Review available metrics
profiling data
0
Data
PromptBeginner5 minmarkdownQuality: 24
- Analyze algorithmic complexity
data structure choices
0
Creative
PromptBeginner5 minmarkdownQuality: 24
- Plans for failure modes including stampede
cold start
0
Data
PromptBeginner5 minmarkdownQuality: 24
- Leverage Redis data structures (Sorted Sets
HyperLogLog
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
- Avoid embedding volatile data (timestamps
random values) in keys that should be shared
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
Creative
PromptBeginner5 minmarkdownQuality: 24
- Design load tests simulating cache stampede
hot key
0
Data
PromptBeginner5 minmarkdownQuality: 28
- Event-driven invalidation: Publish cache invalidation events on data changes
scalable for distributed systems
0
Data
PromptBeginner5 minmarkdownQuality: 24
- Database caching: Query result caching
materialized views
0
Data
PromptBeginner5 minmarkdownQuality: 28
- Distributed caching: Redis clusters for shared state
Memcached for simple key-value hot data
0
Data
PromptBeginner5 minmarkdownQuality: 24
- Calculate cache memory requirements based on data size
cardinality
0
Data
PromptBeginner5 minmarkdownQuality: 24
- Identify hot data sets
access patterns
0
Creative
PromptBeginner5 minmarkdownQuality: 28
- Select optimal caching technologies based on use case requirements
designing hybrid solutions that combine multiple technologies including CDN and edge caching
0
Creative
PromptBeginner5 minmarkdownQuality: 24
- Design from the outside in: CDN layer
application cache layer
0
Data
PromptBeginner5 minmarkdownQuality: 24
- Ensure data consistency by designing invalidation workflows
eventual consistency patterns
0
Creative
PromptBeginner5 minmarkdownQuality: 24
- Design multi-layer caching architectures using Redis
Memcached
0