MySQL Forums
Forum List  »  Optimizer & Parser

This is strange
Posted by: brian clarke
Date: January 29, 2008 05:27AM

I have two tables that are the same. They have the same indexs, columns etc. Both running in myisam. They have a simalar amount of in both tables at around 400,000 rows.

However when i run the same query on these tables one takess about 20 seconds the first time it is run with Subsequent runs taking about a second.

The other table first run only takes 8 or 9 seconds ith Subsequent runs taking about a second again.

Explain shows that they are running the same.

why is one table taking so much longer?

Options: ReplyQuote


Subject
Views
Written By
Posted
This is strange
3551
January 29, 2008 05:27AM
2285
April 04, 2008 12:35AM


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.