Weblog:   Trees in MySQL 5.0
Subject:   As a programmer, I like it
Date:   2005-04-19 09:04:16
From:   adamsj
As an administrator, I'd want to compare its performance to that of making multiple trips.
Full Threads Newest First

Showing messages 1 through 2 of 2.

  • As a programmer, I like it
    2005-04-19 09:17:43  chromatic | O'Reilly AuthorO'Reilly Blogger [View]

    The other session I attended, about performance and tuning, made the point that benchmarking is tricky. Sure, there's less network traffic, which is nice, but there are things to consider like holding read locks for longer (or is it longer?) and the amount of space taken up by the temporary table. (If it grows too large, it needs to write to the disk.)

    Still, I look forward to trying it.
    • John W. Adams photo Yeah, it's a nice hack
      2005-04-19 10:07:26  John W. Adams | O'Reilly Blogger [View]

      Typically, when I've had to do this, I was working with the data dictionary, which means just one pull from the database. Then I've used Class::Struct to build a simple tree. That puts the simple processing on the desktop or the app server, not on the database. (Maybe it's just that I've typically worked with systems that were pretty well redlined, but I always want to take work off the RDBMS.)

      If you're doing something else, the question of multiple pulls becomes more important.

      I guess that's just a long-winded way of saying I want to try it, too.

Showing messages 1 through 2 of 2.