Comparing Database performance with Django ORM

• Postgresql
• MySQL
• MariaDB
• SQLite
• CockoroachDB

Comparing database operation performance using django ORM.

PostgreSQL vs MySQL vs MariaDB vs SQLite vs CockoroachDB

The results given below are based on AWS T2 micro

Insert performance comparison

Tested 1000 row insert in all databases and calculated time is taken.

Bulk Insert performance comparison

Tested 1000 row bulk insert in all databases and calculated time is taken.

Bulk Delete performance comparison

Tested 1000 row delete in all databases and calculated time is taken.

Bulk Delete performance comparison

Tested 1000 row bulk delete in all databases and calculated time is taken.

Update performance comparison

Tested 1000 row update in all databases and calculated time is taken.

Bulk update performance comparison

Tested 1000 row bulk update in all databases and calculated time is taken.

Select performance comparison

Tested 1000 in 1000 rows select operation in non indexed column in all databases and calculated time is taken.

Select index performance comparison

Tested 1000 in 1000 rows select operation in indexed column in all databases and calculated time is taken.

Installation

• install docker and docker compose
• clone repository
• run ./start.sh
• result will be stored in reports/graph