Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
toad.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
Mastodon server operated by David Troy, a tech pioneer and investigative journalist addressing threats to democracy. Thoughtful participation and discussion welcome.

Administered by:

Server stats:

298
active users

toad.social: AboutProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.8

#PerformanceOptimization

0 posts0 participants0 posts today
Public
Chris Woody Woodruff

Tired of adding the same WHERE clause everywhere? Let EF Core do the work!

With Global Query Filters, you can set the rules once and let EF Core apply them automatically—perfect for soft deletes, multi-tenancy, and more.

Learn how: woodruff.dev/global-query-filt

Chris Woody Woodruff · Global Query Filters: Setting the Rules Once, Querying Like a Pro - Chris Woody WoodruffImagine you’re running a café. Every customer who walks in gets a free cookie—no need to ask for it, no need for your staff to remember. It just happens, automatically. That’s the magic of Global Query Filters in EF Core. Once you set them up, every query automatically follows the rules, making your code simpler and your life easier. Global Query Filters are all about efficiency and consistency. Let’s dive into how they work, why they’re awesome, and how to sprinkle them into your EF Core projects like those cookies at your café.
#EFCore#dotnet#DevTips
Public
Chris Woody Woodruff

Still saving EF Core updates one at a time? There’s a better way!

Batching Updates & Inserts lets you send multiple changes in a single DB call—reducing trips, saving resources, and boosting performance.

Learn how to make EF Core work smarter, not harder: woodruff.dev/batching-updates-

Chris Woody Woodruff · Batching Updates and Inserts: Making EF Core Work Smarter, Not Harder - Chris Woody WoodruffLet’s face it: making multiple database calls is like running back and forth between the kitchen and dining room to serve dinner one plate at a time. It’s inefficient, exhausting, and makes your app look like it’s stuck in the Stone Age. But with batching in EF Core, you can wave goodbye to this inefficiency. It's the magic trick that lets you update or insert multiple records in a single trip to the database, making you and your app more productive and efficient. Batching is all about doing more with less. It minimizes round trips to the database, saves resources, and makes your app faster. Understanding and implementing batching in EF Core is like gaining a superpower-it makes your app work smarter, not harder, and gives you a sense of control and confidence in your development process.
#EFCore#dotnet#PerformanceOptimization
Public
Chris Woody Woodruff

Want faster EF Core queries? Meet No-Tracking!

If you’re just reading data, why have EF Core track it? AsNoTracking() boosts performance by skipping unnecessary overhead, making it perfect for reports, APIs, and dashboards.

Learn how: woodruff.dev/no-tracking-queri

Chris Woody Woodruff · No-Tracking Queries: Speed Up Your EF Core Like a Pro - Chris Woody WoodruffImagine you’re at a library, flipping through books at lightning speed. You don’t need to write notes in the margins or keep tabs on which books you’ve touched—you’re just reading. That’s what no-tracking queries are in EF Core: a way to grab data without keeping track of changes. It’s fast, lightweight, and perfect for read-only operations. But wait, there’s more! Let’s throw identity resolution into the mix, a smart way to avoid duplicate entities when working with no-tracking queries. Together, they make a dynamic duo for blazing-fast data fetching, significantly reducing the time it takes to retrieve data from the database.
#EFCore#dotnet#PerformanceOptimization
Public
Chris Woody Woodruff

Stop hauling more data than you need in EF Core! Query Projection lets you fetch only the fields that matter, keeping your queries lean and fast.

No more SELECT *—it’s time to optimize!

Learn how: woodruff.dev/query-projection-

Chris Woody Woodruff · Query Projection: Stop Hauling More Data Than You Need! - Chris Woody WoodruffImagine you’re moving to a new house. You could pack only the essentials and enjoy a stress-free move, or you could drag everything you own—grandma’s old lamp, that broken treadmill, and a box labeled “random cables.” This analogy of moving to query projection makes the concept familiar and relevant. Moving with all that clutter? Nightmare. The same applies to your EF Core queries. Why fetch every column in a table when all you need is a handful of them? That’s where query projection comes in. It’s all about keeping your data lean, clean, and most importantly, efficient. Embracing query projection is like optimizing your coding practices for maximum efficiency.
#EFCore#dotnet#PerformanceOptimization
Public
Chris Woody Woodruff

Tired of your EF Core queries causing traffic jams? Split Queries to the rescue!

Break big joins into smaller, faster queries and keep your app running smoothly.

Learn how to split smart: woodruff.dev/split-queries-sto

Chris Woody Woodruff · Split Queries: Stop the Data Traffic Jam in EF Core - Chris Woody WoodruffPicture this: You’re hosting a dinner party, and instead of serving everyone a delicious buffet, you deliver each dish one at a time to every guest. When dessert arrives, everyone’s too tired (or annoyed) to enjoy it. My friends, this is the problem with single queries in EF Core when they fetch complex relationships. Enter Split Queries, the life of your EF Core dinner party.
#EFCore#dotnet#aspnet
Public
Chris Woody Woodruff

Turbocharge your C# .NET and ASP.NET EF Core apps!

Learn how DbContext Pooling cuts down context creations, boosts performance, and saves your app from burnout. Get the secret sauce to faster queries!

Read more: woodruff.dev/dbcontext-pooling

Chris Woody Woodruff · DbContext Pooling: The Secret Sauce to Faster EF Core Apps - Chris Woody WoodruffImagine you’re running a restaurant. Every time a customer orders, you buy a brand-new frying pan, use it once, and toss it out. Sounds absurd, right? But that’s essentially what happens in EF Core when you create a new DbContext for every request. It’s wasteful, slow, and totally unnecessary. Enter DbContext Pooling: the genius way to reuse those frying pans—err, contexts—and turbocharge your app’s performance.
#EFCore#dotnet#aspnet
Public *
Chris Woody Woodruff

📢 Exciting News! The latest chapter on "Network Performance Optimization" in my book Beyond Boundaries—Network Programming with C# 12 and .NET 8 has been released!

🔍 **Topics Covered:**
- Using Visual Studio Profiler & JetBrains dotTrace
- .NET Trace & WireShark for performance analysis
- Key metrics, bottleneck identification, and optimization techniques

Optimize your network applications today!
csharp-networking.com/chapter0

csharp-networking.comNetwork Performance OptimizationOptimizing network performance is pivotal for developing robust and efficient applications in network programming using .NET 8 and C #12.
#CSharp#DotNet#NetworkProgramming
Replied in thread
Public
Jeff Grigg

@larryosterman @ekuber @heaths

[ Surprising #PerformanceOptimization ]

In the late 1990s I was building a system where we needed to load lots of data into an Access database as quickly as possible. Naturally, we were using the native ADO COM interface of the Access Jet engine to do so.

Someone got a crazy idea and tried the more generic ODBC interface, which works across all databases. It was substantially faster.

Seems that ADO was designed for ease of use. ODBC for performance.

ExploreLive feeds
About