Analyzing CRUD Performance and Data Integrity Trade-offs in MariaDB: The Impact of Indexes, Foreign Keys, and Referential Actions
Data integrity in RDBMS frequently raises concerns regarding computational efficiency, particularly when handling large-scale datasets. This study analyzes the trade-off between execution time and storage overhead in MariaDB (InnoDB storage engine) by evaluating different configurations of indexing, foreign key constra...