{"repo":"sarathak/django-db-benchmark","free":true,"listed":false,"github":"https://github.com/sarathak/django-db-benchmark","clone":"git clone https://github.com/sarathak/django-db-benchmark.git","description":"Django ORM Database Performance Benchmark","language":"Python","stars":27,"topics":["django","databases","performance-analysis","postgresql","mysql","sqlite","mariadb"],"license":"MIT","category":"databases-storage","readme_excerpt":"Django ORM Database Performance Benchmark This project benchmarks and compares the performance of popular SQL databases using the Django ORM. It provides detailed metrics for common database operations across different database backends. Databases tested: - PostgreSQL - MySQL - MariaDB - SQLite - CockroachDB Overview Measure and compare the speed of database operations (insert, bulk insert, delete, bulk delete, update, bulk update, select, and indexed select) using Django ORM on AWS T2 micro instances. Results include execution time and performance graphs for each operation and database. Benchmark Results Insert Performance Comparison Tested 1000 row inserts in all databases and measured execution time. Bulk Insert Performance Comparison Tested 1000 row bulk inserts in all databases and measured execution time. Delete Performance Comparison Tested 1000 row deletes in all databases and measured execution time. Bulk Delete Performance Comparison Tested 1000 row bulk deletes in all databases and measured execution time. Update Performance Comparison Tested 1000 row updates in all databases and measured execution time. Bulk Update Performance Comparison Tested 1000 row bulk updates in all databases and measured execution time. Select Performance Comparison (Non-Indexed Column) Tested 1000 select queries on non-indexed columns in all databases and measured execution time. Select Performance Comparison (Indexed Column) Tested 1000 select queries on indexed columns in all databases ","default_branch":null,"files":null,"tree":[],"storefront":"/r/sarathak","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/sarathak/django-db-benchmark/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}