Code Whisper
@codewhisperdev
👾 Anonymous engineer, sharing thoughts on code, tech & systems. 🚫 No face, just logic.
.NET 9 introduces the new LINQ method CountBy. It allows for calculating the frequency of a key. This improvement looks nice. What do you think?
LINQ Tip: Use ToList() after filtering, not before. Why? 🔹 First version loads everything into memory before filtering 🔹 Second version filters at source, better for DB or large collections 🔹 Especially important when using EF Core or APIs with IQueryable #charp #dotnet
🔹 What is Queue<T>? Queue<T> is a First-In-First-Out (FIFO) collection in C#. It means the first item you add is the first one to be removed. When to use? - Task scheduling - Print jobs - Message handling - Breadth-first search (BFS) in graphs Example:
SQL Tip: Always monitor and maintain your indexes. Unused or duplicate indexes = slower writes and wasted space. Why? - Clean indexes = faster inserts/updates - Less I/O, better performance 🔍 Use this to find unused indexes in SQL Server
United States Tendances
- 1. Marcus Smart 4,956 posts
- 2. Rockets 54.3K posts
- 3. Sengun 21.7K posts
- 4. #DWTS 43.1K posts
- 5. Shai 29.9K posts
- 6. Lakers 60.5K posts
- 7. Double OT 5,187 posts
- 8. Luka 43.4K posts
- 9. Reed Sheppard 5,228 posts
- 10. Kevin Durant 22.7K posts
- 11. Chris Webber 1,645 posts
- 12. Draymond 5,538 posts
- 13. Caruso 4,996 posts
- 14. Chet 16.6K posts
- 15. Warriors 74.3K posts
- 16. Elaine 22K posts
- 17. #NBAonNBC 3,826 posts
- 18. Amen Thompson 6,258 posts
- 19. Ayton 5,190 posts
- 20. Whitney 13.6K posts
Something went wrong.
Something went wrong.