Optimize Ecto Query Performance by Controlling Field Loading

This article highlights an issue encountered when using Ecto with large jsonb fields, particularly in the context of identifying performance bottlenecks in a web application. When fetching records with many associated large fields, the application's speed can significantly decrease. The author proposes a solution using the `load_in_query` option, allowing developers to specify whether to load large fields only when necessary. By setting this option to false for certain fields, Ecto will not load them by default, thus improving query performance. The article provides code examples to demonstrate how to implement this optimization effectively.