This repository presents research on SQL query optimization, exploring how different indexing strategies and PostgreSQL configurations impact query performance. The project, which earned second place at TCCD Research Day, provides insights into improving database efficiency.
Database performance analyzer — slow queries, EXPLAIN plans, index efficiency. Go + React.
SQL Database Normalization and Advanced Queries
A back-end project to optimise an online bookstore's database performance using Indexes in PostgreSQL
An ML-powered middleware that intercepts slow SQL queries, uses regression models to predict execution times, and leverages a fine-tuned LLM to automatically rewrite inefficient code. Features Redis caching, connection pooling, and database replication for peak backend performance.
SQL Server DBA Projects
Add a description, image, and links to the database-performance-optimization topic page so that developers can more easily learn about it.
To associate your repository with the database-performance-optimization topic, visit your repo's landing page and select "manage topics."