Slow SQL queries

Hey,

Many people think, that it is faster to use this option than run two separate queries: one - to get a result set, another - to count total number of rows.

Here is little example:

Try to run this SQL (Dont forget change prefix):

Code:

---

Only registered members can view the code.

---

Query took 2.5705 seconds.

Why?
Read here:
https://www.percona.com/blog/2007/08...lc_found_rows/