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 เทรนด์
- 1. White Sox 14.7K posts
- 2. Ugarte 13.9K posts
- 3. #AskFFT 1,018 posts
- 4. Morgan Rogers 3,207 posts
- 5. Joan Garcia 12.4K posts
- 6. Murakami 17.5K posts
- 7. Happy Winter Solstice 11.8K posts
- 8. Yoro 4,928 posts
- 9. Estime 6,539 posts
- 10. Good Sunday 75.7K posts
- 11. #sundayvibes 5,607 posts
- 12. Sesko 8,829 posts
- 13. #AVLMUN 4,897 posts
- 14. Lamine 33K posts
- 15. Full PPR 1,786 posts
- 16. Villarreal 22.9K posts
- 17. Michael Wilson 1,231 posts
- 18. #FirstDayOfWinter N/A
- 19. Sutton 2,374 posts
- 20. Dorgu 4,228 posts
Something went wrong.
Something went wrong.