Explain the trade-offs between different database architectures for high-read versus high-write workloads.