Explore the newsletters

78 blogs found
How I Optimized EF Core Query from 30 Seconds to 30 Milliseconds
ef-core

How I Optimized EF Core Query from 30 Seconds to 30 Milliseconds

How to optimize a slow EF Core database query in Postgres: filter only needed rows, limit the number of JOINs, select only the columns you need, limit number of requests, avoid cartesian explosion and deep sub queries. Select the most optimal option in terms of performance and memory usage. Remember the golden software rule: measure first, then optimize.

Improve Your .NET and Architecture Skills

Join my community of 10,000+ developers and architects.

Each week you will get 1 practical tip with best practices and real-world examples.

Learn how to craft better software with source code available for my newsletter.

Join 10,000+ developers already reading
No spam. Unsubscribe any time.