What are the trade-offs between using a relational database (SQL) versus a non-relational database (NoSQL) for a high-traffic web application?