Please see https://github.com/KevinL10/applovin-query for a detailed README!
A submission to AppLovin's query planner challenge at Cal Hacks 2025.
Summary: we achieve a ~1300x speedup compared to the baseline implementation (~45s to ~30ms) on an M3 Pro with 18 GB RAM. Preprocessing takes 300.5 seconds (~5 minutes).
We use four main techniques (more detail at https://github.com/KevinL10/applovin-query):
- Efficient on-disk storage layout
- Materialized views
- Intelligent query planning & rewriting
- Efficient caching and warmup
Log in or sign up for Devpost to join the conversation.