[wp-trac] [WordPress Trac] #10469: use of SQL_CALC_FOUND_ROWS needs to be eliminated

[WordPress Trac]

#10469: use of SQL_CALC_FOUND_ROWS needs to be eliminated
--------------------------+-----------------------------
 Reporter:  _ck_          |       Owner:  ryan
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Future Release
Component:  Query         |     Version:  2.9
 Severity:  normal        |  Resolution:
 Keywords:  dev-feedback  |
--------------------------+-----------------------------

Comment (by scribu):

 A different (and not properly tested) approach: #10964

 Also note that as of WP 3.1, meta queries also use JOINs.

 Perhaps the optimal approach would be to use COUNT(*) when $join is empty.

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