This project benchmarks MySQL and PostgreSQL databases using Node.js. It utilizes popular libraries for database connections and performs benchmark queries to evaluate performance.
Rename .env.example to .env
docker compose up -d
npm install
npm run bootstrap
npm run mysql
npm run psql
Mysql Benchmark Results:
Query 1: Average Execution Time: 1.10 ms
Query 2: Average Execution Time: 15001.02 ms
Query 3: Average Execution Time: 2.34 ms
Query 4: Average Execution Time: 145.52 ms
Query 5: Average Execution Time: 41.97 ms
Query 6: Average Execution Time: 132.49 ms
Query 7: Average Execution Time: 3.20 ms
PostgreSQL Benchmark Results:
Query 1: Average Execution Time: 1.29 ms
Query 2: Average Execution Time: 87.67 ms
Query 3: Average Execution Time: 0.96 ms
Query 4: Average Execution Time: 24.01 ms
Query 5: Average Execution Time: 18.10 ms
Query 6: Average Execution Time: 25.84 ms
Query 7: Average Execution Time: 60.98 ms
Mysql Benchmark Results:
Query 1: Average Execution Time: 3.19 ms
Query 2: Average Execution Time: 15110.57 ms
Query 3: Average Execution Time: 1.99 ms
Query 4: Average Execution Time: 145.61 ms
Query 5: Average Execution Time: 39.70 ms
Query 6: Average Execution Time: 137.77 ms
Query 7: Average Execution Time: 8.76 ms
PostgreSQL Benchmark Results:
Query 1: Average Execution Time: 30.62 ms
Query 2: Average Execution Time: 3598.88 ms
Query 3: Average Execution Time: 1.56 ms
Query 4: Average Execution Time: 26.36 ms
Query 5: Average Execution Time: 20.78 ms
Query 6: Average Execution Time: 27.67 ms
Query 7: Average Execution Time: 81.08 ms