WordPress.org
Get WordPress

Make WordPress Core

Opened 17 years ago

Closed 17 years ago

#12557 closed defect (bug) (fixed)

get_boundary_post() causes slow SQL_CALC_FOUND_ROWS query.

Reported by: ryan Owned by:
Priority: normal Milestone: 3.0
Component: Performance Version: 2.9.2
Severity: normal Keywords:
Cc: Focuses:

Description

get_boundary_post() should pass no_paging to get_posts() so that it doesn't trigger a pointless and slow SQL_CALC_FOUND_ROWS query.

Change History (2)

#1 @ryan
17 years ago

nopaging turns off limits entirely. WP_Query::get_posts() needs some rework to allow limiting the number of posts without turning on found rows.

#2 @automattor
17 years ago

  • Resolution → fixed
  • Status new → closed

(In [13647]) Add no_found_rows argument to WP_Query::get_posts() to allow forcibly defeating SQL_CALC_FOUND_ROWS. Use no_found_rows for the query in get_boundary_post(). fixes #12557

Note: See TracTickets for help on using tickets.