Weblog:   Trees in MySQL 5.0
Subject:   As a programmer, I like it
Date:   2005-04-19 09:17:43
From:   chromatic
Response to: As a programmer, I like it

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.

Full Threads Oldest First

Showing messages 1 through 1 of 1.

  • 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 1 of 1.