Changeset 4455 - SELECT FOUND_ROWS() faster than count()?

[alexkingorg]

This change looks like it resolves ticket 3274 in a different way than the patch. I'm wondering if an additional query is faster/slower than counting the array we already have as a PHP variable.

​http://trac.wordpress.org/ticket/3274

[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?

[markjaquith]

Austin Matzko on wp-hackers notes that SQL_CALC_FOUND_ROWS requires MySQL 4.0, while WordPress up 'til now has worked on MySQL 3.23.23

Just as FYI. I'm fine leaving MySQL 3 in the dust. Matt may feel differently.

[ryan]

We're going to bump the MySQL requirement for 2.1.

So far this is proving useful on wordpress.com. I'll resolve as fixed.