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 Trends
- 1. Mike Evans 7,239 posts
- 2. Gibbs 13.2K posts
- 3. #WWERaw 17.4K posts
- 4. Lions 62.4K posts
- 5. Bucs 14.3K posts
- 6. #OnePride 4,842 posts
- 7. Josh Naylor 2,846 posts
- 8. Goff 6,810 posts
- 9. White House 215K posts
- 10. $BIGMI 1,651 posts
- 11. #TBvsDET 3,038 posts
- 12. Dragon Lee 1,094 posts
- 13. Baker Mayfield 4,697 posts
- 14. Ben Solo 9,520 posts
- 15. FanDuel 23K posts
- 16. East Wing 39.9K posts
- 17. Bron 18.5K posts
- 18. #RawOnNetflix N/A
- 19. #MondayNightFootball 1,074 posts
- 20. Game 7 54.6K posts
Something went wrong.
Something went wrong.