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/