MySQL Forums
Forum List  »  Performance

Re: optimizing count statement
Posted by: Felix Geerinckx
Date: October 12, 2005 08:38AM

Karolis wrote:

> The question is whether it is going to take longer when the
> database grows? Say if I have 20 million rows instead of 1 million?


Wait and see ;-)

Could you post the EXPLAIN for both a small and a larger set?

--
felix
Please use BBCode to format your messages in this forum.

Options: Reply• Quote


Subject
Views
Written By
Posted
4347
October 11, 2005 11:30AM
2055
October 12, 2005 04:56AM
1957
October 12, 2005 06:31AM
1625
October 12, 2005 07:11AM
1861
October 12, 2005 07:40AM
1751
October 12, 2005 07:53AM
1934
October 12, 2005 07:50AM
1911
October 12, 2005 08:01AM
1882
October 12, 2005 08:05AM
1628
October 12, 2005 08:23AM
1905
October 12, 2005 08:22AM
Re: optimizing count statement
1861
October 12, 2005 08:38AM
1997
October 12, 2005 08:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.