Skip to content

Latest commit

 

History

History
65 lines (38 loc) · 1.73 KB

README.md

File metadata and controls

65 lines (38 loc) · 1.73 KB
Raw

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.

Insert

Bulk Insert performance comparison

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

Insert

Bulk Delete performance comparison

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

Insert

Bulk Delete performance comparison

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

Insert

Update performance comparison

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

Insert

Bulk update performance comparison

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

Insert

Select performance comparison

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

Insert

Select index performance comparison

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

Insert

Installation

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