Count(*) took 5 seconds
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
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.