# Count .... Group By... any other way?

**URL:** <https://forums.percona.com/t/count-group-by-any-other-way/97>\
**Category:** Other MySQL® Questions\
**Created:** [October 9, 2006, 10:06am UTC](https://forums.percona.com/t/count-group-by-any-other-way/97 "2006-10-09T10:06:32Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)\
**Post date:** [October 9, 2006, 11:14am UTC](https://forums.percona.com/t/count-group-by-any-other-way/97/2 "2006-10-09T11:14:42Z")

</div>

It would be helpful if you could provide both EXPLAIN statements and queries without COUNT and with count.

I expect in your case there is large amount of matches (so it is not really 8x21 rows you could see in the stats) so temporary table is needed etc.

I also should ask you why are you trying to implement search engine in SQL ? It is going to be slow as you will have to traverse very many rows for common keywords.

---

_[View the full topic](https://forums.percona.com/t/count-group-by-any-other-way/97)._