Database benchmarking on indexed vs non-indexed table for PostgreSQL. Uses kotlin engine.
- Run
docker compose upto start a containerized postgreSQL database locally. - Run all cells in
Dataset-Generation.ipynb, it will initalize the tables, schemas and populate the database with some initial patients and staff members. - Run first two cells in
Database-BenchMarking.ipynbto initalize imports. Then run respective cells based on what you want to benchmark.