Prompt

Optimize database architecture for scale.

<current_database>
- Type: {RDBMS/NoSQL}
- Size: {data volume}
- Load: {queries per second}
</current_database>

<scaling_requirements>
- Expected growth: {describe}
- Read/write ratio: {ratio}
- Consistency needs: {strong/eventual}
</scaling_requirements>

<pain_points>
{describe current bottlenecks}
</pain_points>

Optimize architecture:
1. Partitioning/sharding strategy
2. Read replica configuration
3. Caching layers
4. Index optimization
5. Query optimization
6. Migration approach

Consider CAP theorem tradeoffs.