Count(*) took 5 seconds
Posted by: Christian Brosig
Date: October 06, 2005 12:21AM

Hi all,

we are using a mysql databse (4.0).
There is not a really lot of data inside. But I have a problem if I like to get the count(*) for a result of a join of two tables. In both tables there are about 150.000 datasets. The result set is 145.000 datasets.
The count(*) takes about 5 seconds. I have an index on the colums which are used for the join.

How can I tune the database to be much quicker? Is there anything I can do?

I am happy about any hint or comment.

Thanks!

Christian

Options: ReplyQuote


Subject
Written By
Posted
Count(*) took 5 seconds
October 06, 2005 12:21AM


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.