Explain the performance trade-offs between using a relational database versus a NoSQL database for a high-throughput messaging application.