[wp-trac] [WordPress Trac] #23336: Sticky Posts lack sanity bounding. If used too much, can severely degrade performance.

[WordPress Trac]

#23336: Sticky Posts lack sanity bounding. If used too much, can severely degrade
performance.
-----------------------------------------+------------------
 Reporter:  markjaquith                  |       Owner:
     Type:  defect (bug)                 |      Status:  new
 Priority:  normal                       |   Milestone:  3.6
Component:  Query                        |     Version:
 Severity:  normal                       |  Resolution:
 Keywords:  has-patch reporter-feedback  |
-----------------------------------------+------------------

Comment (by iandunn):

 mbijon, the patch only limits how many sticky posts will be displayed on
 the home page, and there's a filter around the value so people can easily
 change it. It doesn't effect anything else regarding creating or using
 sticky posts.

 Does that still pose a concern for you? If so, can you give an example use
 case where someone would want to show 100+ posts on the home page? If
 there are some, maybe the default limit should be relaxed to 175 or even
 250. Given the bug markjaquith describes, though, that still might not be
 enough reason to remove the limit completely.

 I agree that the way sticky posts are currently managed isn't great, but
 that's kind of tangential to this ticket. If #12702 was going to be
 committed soon, then that would make this one irrelevant, but it doesn't
 seem like there's anything close to a consensus there, and it's definitely
 not gonna make it into 3.6. So, I would think it'd be a good idea to go
 ahead with this ticket to fix the current bug, rather than waiting for a
 comprehensive refactoring of sticky posts to happen.

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