MPTtree, Hieararchical trees in a database table

[eluser]sshz[/eluser]
TheFuzzy0ne, thanks.

Now my schema is:

Code:

CREATE TABLE `pyro`.`goods` (
`id` int(10) unsigned NOT NULL auto_increment,
`lft` int(10) unsigned NOT NULL,
`rgt` int(10) unsigned NOT NULL,
`title` varchar(100) NOT NULL,
`long_title` VARCHAR( 255 ) NOT NULL ,
`short_desc` VARCHAR( 255 ) NOT NULL ,
`long_desc` VARCHAR( 255 ) NOT NULL ,
`price` VARCHAR( 10 ) NOT NULL ,
`pic` VARCHAR( 100 ) NOT NULL ,
`sort` INT( 10 ) NOT NULL ,
`special` INT( 10 ) NOT NULL,
PRIMARY KEY  (`id`),
KEY `lft` (`lft`),
KEY `rgt` (`rgt`)
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci

It's got a lot better with indexing, get_children query for 6,500 elements tree took only 5 seconds, but it's not good enough, any more clues?

Code:

$root = $this->MPTtree->get_root();
        $children = $this->MPTtree->get_children($root['lft'], $root['rgt']);