COMPARING SQL AND NOSQL DATABASE PERFORMANCE FOR HANDLING HIGH TRAFFIC IN E-COMMERCE WEB APPLICATIONS

Abstract

The need for handling a large amount of data, combined with the fast evolution of e-commerce sites, has made it important for databases to work smoothly and at scale. By examining different research and benchmarks, it points out what makes MySQL and PostgreSQL solid relational databases compared to MongoDB and Cassandra as non-relational databases. SQL databases provide reliable results and work well with complex sets of commands. NoSQL databases are better at growing without vertical boundaries, withstanding failures, and being flexible, so they are great for web applications handling a huge amount of traffic. The research also analyzes what specifications are important in e-commerce platforms, features of web applications, and methods that make it possible to see how databases perform when things are changing.