[wp-trac] [WordPress Trac] #16574: Lazy load ancestors

[WordPress Trac]

#16574: Lazy load ancestors
---------------------------------+-----------------------------
 Reporter:  nacin                |       Owner:
     Type:  enhancement          |      Status:  new
 Priority:  normal               |   Milestone:  Future Release
Component:  Performance          |     Version:
 Severity:  normal               |  Resolution:
 Keywords:  3.2-early has-patch  |
---------------------------------+-----------------------------

Comment (by johnjamesjacoby):

 As a general update, 16574.3.diff is still good. I've been running several
 .org installs with it since posted with only positive results. It doesn't
 add any fancy magic functions, but it does at least give ancestor queries
 the opportunity to hit the WP cache instead of always hitting the DB.

 Any install with a page widget and a page menu would see a noticeable
 decrease in DB hits with this patch alone. The bbPress plugin sees a
 dramatic decrease (of sometimes 10+ queries) because it relies heavily on
 the hierarchy to manage the post relationships between
 forums/topics/replies.

 If there are alternatives (magic functions, etc...) I'd love to
 collaborate on them to test the benefits.

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