Back to omegaUp
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

Contributor

mazapan

Mentors

Not available

Technologies

Not listed in the archive