Performance tips and tricks

Consider parallel execution.

Common approaches:

• Use Task.WhenAll()
• Process independent tasks concurrently
• Increase consumer instances
• Batch operations when possible
• Remove unnecessary bottlenecks

Parallel processing allows multiple operations to run at the same time rather than waiting for each to finish.

For example:

• 10 API calls executed sequentially may take 10 seconds
• 10 API calls executed in parallel may take around 1 second

Of course, parallelism isn't free. Databases, external APIs, and infrastructure still have limits.

But if your workload is independent, parallel execution is often one of the simplest ways to increase throughput.

What was the biggest throughput improvement you've achieved?

Queries running slowly?

Consider adding an index.

Indexes help SQL Server:

• Find data faster
• Reduce table scans
• Improve filtering performance
• Improve sorting performance
• Improve join performance

Not every column needs an index, but columns used in WHERE clauses often benefit from one.

What is your favorite indexing strategy?

Want asynchronous database writes in EF Core?

Use SaveChangesAsync() instead of SaveChanges().

Benefits:

• Doesn't block the calling thread
• Works better under load
• Integrates with async/await
• Recommended for ASP.NET Core applications
• Available since EF Core was released

What other EF Core performance tips do you use?