[wp-trac] [WordPress Trac] #8384: Improving WP hierarchical data structure / Use SQL trees

[WordPress Trac]

#8384: Improving  WP hierarchical data structure / Use SQL trees
-----------------------------+----------------------------------------------
 Reporter:  hailin           |       Owner:  hailin        
     Type:  feature request  |      Status:  assigned      
 Priority:  low              |   Milestone:  Future Release
Component:  Optimization     |     Version:                
 Severity:  minor            |    Keywords:                
-----------------------------+----------------------------------------------

Comment(by diegocaro):

 Hello! The two students are me and Dan Larkin. We were working on MPTT for
 WordPress in pages and categories.

 In a short resume, I only get performance in admin panel (comparision
 between trunk WP and WP-MPTT with the new metadata in the database). For
 any reason, I can't get more improvement in the other sections of
 WordPress. I think that when WP get the data from mysql, WP take more time
 beacause get the metadata (left, right and depth fields). May if you read
 the code, you can get the reason of the non-perfermance.

 Dan Larking work was great, him make code with acceleration in normal
 WordPress page, but no in admin panel (I guess).

 I think that a good idea is put my code of admin panel, and put the code
 of Dan in WordPress Core.

 My patch is in http://google-summer-of-
 code-2009-wordpress.googlecode.com/files/Diego_Caro.tar.bz2 and Dan Larkin
 patch is in http://google-summer-of-
 code-2009-wordpress.googlecode.com/files/Daniel_Larkin.tar.bz2

 You can see the history of our work in MPTT-WordPress in
 http://gsoc2009wp.wordpress.com/tag/mptt/

 Bye bye!

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/8384#comment:11>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software