[wp-trac] Re: [WordPress Trac] #3347: Changeset 4455 - SELECT FOUND_ROWS() faster than count()?

[WordPress Trac]

#3347: Changeset 4455 - SELECT FOUND_ROWS() faster than count()?
-------------------------+--------------------------------------------------
 Reporter:  alexkingorg  |        Owner:  ryan
     Type:  defect       |       Status:  new 
 Priority:  normal       |    Milestone:  2.1 
Component:  General      |      Version:  2.1 
 Severity:  normal       |   Resolution:      
 Keywords:               |  
-------------------------+--------------------------------------------------
Comment (by ryan):

 In my testing, SELECT FOUND_ROWS() is extremely fast, and adding
 SQL_CALC_FOUND_ROWS to the post query has minimal overhead.  Overall, it's
 faster for me than doing another SELECT FROM.  What are your impressions
 so far?

-- 
Ticket URL: <http://trac.wordpress.org/ticket/3347#comment:1>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software