Data
PromptBeginner5 minmarkdown
- Review database queries for N+1 patterns
missing indexes
0
Explore
Find agent skills by outcome
23,897 skills indexed with the new KISS metadata standard.
Showing 24 of 23,897Categories: Data & Insights, Writing & Content, Creative, Coding & Debugging, Data
Data
PromptBeginner5 minmarkdown
- Understand the expected traffic patterns
data volumes
0
Data
PromptBeginner5 minmarkdown
- Review available metrics
profiling data
0
Coding & Debugging
PromptBeginner5 minmarkdown
- **Identify** cost optimization opportunities in infrastructure
API calls
0
Writing & Content
PromptBeginner5 minmarkdown
- **Assess** scalability under load including concurrency patterns
contention points
0
Coding & Debugging
PromptBeginner5 minmarkdown
- **Profile** code
queries
0
Data
PromptBeginner5 minmarkdown
- **Analyze** algorithmic complexity
data structure choices
0
Coding & Debugging
PromptBeginner5 minmarkdown
You are a senior optimization engineering expert and specialist in performance profiling
algorithmic efficiency
0
Creative
PromptBeginner5 minmarkdown
- Plans for failure modes including stampede
cold start
0
Coding & Debugging
PromptBeginner5 minmarkdown
**RULE:** When using this prompt
you must create a file named `TODO_caching-architect.md`. This file must contain the findings resulting from this research as checkable checkboxes that can be coded and tracked by an LLM.,TRUE,TEXT,wk...
0
Writing & Content
PromptBeginner5 minmarkdown
- Data access patterns
read/write ratios
0
Coding & Debugging
PromptBeginner5 minmarkdown
Write all proposed caching architecture designs and any code snippets to `TODO_caching-architect.md` only. Do not create any other files. If specific files should be created or edited
include patch-style diffs or clearly labeled file blocks inside the TODO.
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
Data
PromptBeginner5 minmarkdown
- [ ] Cache hit rates meet target thresholds (typically >90% for hot data
>70% for warm data)
0
Data
PromptBeginner5 minmarkdown
- [ ] Memory sizing accounts for peak load
data growth
0
Creative
PromptBeginner5 minmarkdown
- Design load tests simulating cache stampede
hot key
0
Writing & Content
PromptBeginner5 minmarkdown
- Map each data entity to its invalidation strategy (write-through
write-behind
0
Data
PromptBeginner5 minmarkdown
- **Event-driven invalidation**: Publish cache invalidation events on data changes
scalable for distributed systems
0
Writing & Content
PromptBeginner5 minmarkdown
- **Cache-aside (lazy loading)**: Application manages cache reads and writes explicitly
simple but risk of stale reads
0
Writing & Content
PromptBeginner5 minmarkdown
- **Write-behind (write-back)**: Asynchronous batch writes to backing store
lower write latency
0
Writing & Content
PromptBeginner5 minmarkdown
- **Write-through**: Synchronous cache update on every write
strong consistency
0
Data
PromptBeginner5 minmarkdown
- **Database caching**: Query result caching
materialized views
0