# Using SQL\_CALC\_FOUND\_ROWS vs SELECT COUNT(\*)

**URL:** <https://forums.percona.com/t/using-sql-calc-found-rows-vs-select-count/7707>\
**Category:** Percona Server for MySQL 5.7\
**Tags:** mysql, percona\
**Created:** [June 20, 2020, 7:22pm UTC](https://forums.percona.com/t/using-sql-calc-found-rows-vs-select-count/7707 "2020-06-20T19:22:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![roushenas](https://avatars.discourse-cdn.com/v4/letter/r/b9e5f3/32.png) [@roushenas](https://forums.percona.com/u/roushenas)\
**Post date:** [June 20, 2020, 7:22pm UTC](https://forums.percona.com/t/using-sql-calc-found-rows-vs-select-count/7707/1 "2020-06-20T19:22:16Z")

</div>

It was in 2006 I [heard](https://forums.percona.com/discussion/58/using-sql-calc-found-rows) about SQL\_CALC\_FOUND\_ROWS from @elektronaut, followed by @Peter comment. Since then, a lot of improvement being happened for MySQL. Considering concerns about indices, I am curious if using COUNT(\*) is still faster than using SQL\_CALC\_FOUND\_ROWS.Any thought?

---

<div class="post-metadata">

**Author:** ![daniil.bazhenov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/daniil.bazhenov/32/62_2.png) [@daniil.bazhenov](https://forums.percona.com/u/daniil.bazhenov)\
**Post date:** [July 1, 2020, 7:31am UTC](https://forums.percona.com/t/using-sql-calc-found-rows-vs-select-count/7707/2 "2020-07-01T07:31:38Z")

</div>

Dear @roushenas   
I asked my colleagues at Percona and they find it difficult to answer because it’s been a long time since anyone has checked this.&nbsp;  
Perhaps you can check, take measurements, and share it with us.