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...

Mar 20, 2026

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.

Mar 20, 2026

Data

PromptBeginner5 minmarkdown

- Leverage Redis data structures (Sorted Sets

HyperLogLog

Mar 20, 2026

Data

PromptBeginner5 minmarkdown

- Set TTLs based on data change frequency: seconds for real-time data

minutes for session data

Mar 20, 2026

Data

PromptBeginner5 minmarkdown

- Avoid embedding volatile data (timestamps

random values) in keys that should be shared

Mar 20, 2026

Data

PromptBeginner5 minmarkdown

- [ ] Memory sizing accounts for peak load

data growth

Mar 20, 2026

Data

PromptBeginner5 minmarkdown

- [ ] Cache hit rates meet target thresholds (typically >90% for hot data

>70% for warm data)

Mar 20, 2026

Find agent skills by outcome

- **Unbounded data loading**: Queries or API calls without pagination

- Identify unnecessary copies of large data structures (pandas DataFrames

- Assess removal safety for dead code (Safe

- Classify findings as Reuse Opportunity

- Cite specific code paths

- Dead code

- Loading full datasets instead of streaming

- Propose concrete code changes

- Understand the expected traffic patterns

- Review database queries for N+1 patterns

- Review available metrics

- **Identify** cost optimization opportunities in infrastructure

- **Analyze** algorithmic complexity

- **Profile** code

- Assign each task a stable ID (e.g.

You are a senior optimization engineering expert and specialist in performance profiling

- Treat every requirement below as an explicit

**RULE:** When using this prompt

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

- Leverage Redis data structures (Sorted Sets

- Set TTLs based on data change frequency: seconds for real-time data

- Avoid embedding volatile data (timestamps

- [ ] Memory sizing accounts for peak load

- [ ] Cache hit rates meet target thresholds (typically >90% for hot data

- Unbounded data loading: Queries or API calls without pagination

- Identify cost optimization opportunities in infrastructure

- Analyze algorithmic complexity

- Profile code

RULE: When using this prompt