Published Jun 8, 2015

Hierarchical Data – Adjacency Lists and Nested Set Models

    Dive into the world of hierarchical data with Coding Blocks, as they unravel the intricacies of adjacency lists and the Nested Set Model while offering performance tips and exploring the utility of Recursive Common Table Expressions (CTEs) for managing complex datasets.
    Episode Highlights
    Coding Blocks logo

    Popular Clips

    Episode Highlights

    • Performance Tips

      The hosts highlight the importance of understanding Big O notation for optimizing code performance. Michael Outlaw introduces Big O Cheatsheet, a resource that maps out the performance of various data structure operations, making it easier for developers to recall and apply this critical concept 1. Additionally, they discuss the benefits of compiling .NET applications to native code, which can significantly boost performance. This method reduces memory usage and improves startup times, offering a straightforward way to enhance application efficiency 2.

      This is a really cool resource that you can go to in it maps it all out, you can see which ones are the average performers, which ones are the worst performers, which ones are the best performers for different.

      --- Michael Outlaw

      These tips provide practical ways to improve coding practices and application performance.

         

      Development Tools

      The discussion moves to development tools that can enhance productivity. Joe Zack shares insights on using gaming mice for coding shortcuts, highlighting how programmable buttons can streamline tasks like building and debugging 3. However, not all tools meet expectations; Michael Outlaw recounts his disappointing experience with Resharper, a tool he once praised. Despite its potential, he found it slowed down his workflow and caused frequent issues in Visual Studio 4.

      Visual Studio would hang often, almost always, and you'd get a not responding prompt coming up from Visual Studio, all because you decided it was time to look at another file.

      --- Michael Outlaw

      These insights help developers choose the right tools to enhance their coding efficiency.

    Related Episodes