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):
Query took 2.5705 seconds.Code:Only registered members can view the code.
Why?
Read here:
https://www.percona.com/blog/2007/08...lc_found_rows/