GSoC 2026
Query Optimization and Performance Benchmarking
OmegaUp has around 40 MySQL queries that do full table scans making pages slow for students and teachers. The CI pipeline detects them but never fails the build so they go unnoticed. I will optimize these queries by adding indexes and rewriting them in the DAO layer, make CI block new inefficient queries using an allowlist system, and add a performance benchmark to catch slow queries before they reach production. The goal is to make omegaUp faster today and prevent regressions in the future.
Project details
Technologies
Not listed in the archive