Dealing with a Monster Ecto Query Mackenzie Morgan | ElixirConf EU 2025 | ElixirConf EU 2025

[CodeSync]

Dealing with a Monster Ecto Query Mackenzie Morgan | ElixirConf EU 2025 | ElixirConf EU 2025

This talk was recorded at ElixirConf EU 2025. If you’re curious about our upcoming event, check https://elixirconf.eu

Abstract:
Once upon a time, there was a gnarly query with a lot of OR cases. It was limiting capacity ahead of a high-traffic day. Could it be optimized? Thanks to a few features of Elixir, the answer was yes! Here’s how the Axios mobile app’s capacity increased 600% the day before the 2020 election, in defiance of the standard “push as much processing to the database as possible” advice.

Comments welcome! View the code-sync and elixirconf-eu tags for more Code Sync and ElixirConf EU talks!