What are the trade-offs between different database architectures for a system requiring high-frequency reads and writes?