[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):

 Replying to [comment:11 mboynes]:
 > I'm not a fan of an arbitrary static number like 100. Why not use the
 `posts_per_page` site option instead?

 It's not exactly arbitrary. It's was chosen because it's large enough that
 it won't affect the vast majority of sites, and because there doesn't seem
 to be a reasonable use case for displaying 100+ posts on the home page.
 While you can draw a logical connection between posts_per_page and the
 query limit, it's set to 10 by default, so using it would almost certainly
 result in an unacceptable number of sites being affected.

 The goal here is to just take care of a rare edge case, without affecting
 normal sites. 100 is probably large enough to do that, but 10 is way too
 small.

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