[wp-trac] Re: [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 Denis-de-Bernardy):

 quick notes on the pages.sql file I uploaded:

  - it's best read using pgadmin
  - it contains more than just rgt/lft -- also revisions and permissions
 for a page tree

 the key points of interest is the page_tree() function, when then gets
 used in the various triggers. with PG and triggers, you can get a
 serialized transaction and ensure you've a properly indexed table at all
 times. with MyISAM, you're pretty much guaranteed to get none of that.

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