MySQL Forums
Forum List  »  Performance

Re: Slower machine 100's of times faster??
Posted by: David Wynter
Date: December 21, 2005 09:21AM

I have read Chapters 2, 6 and 7 of Pro MySQL to try to understand why the query in the last posting in this thread takes 21min 49.04 seconds. I cannot see why it should, it has relevant indexes and they are being used.

Can anyone explain why?

Thx.

David

Options: ReplyQuote


Subject
Views
Written By
Posted
2199
December 09, 2005 11:45AM
1433
December 09, 2005 11:51AM
1502
December 09, 2005 11:53AM
1579
December 09, 2005 12:11PM
1365
December 09, 2005 12:12PM
1363
December 09, 2005 12:33PM
1392
December 10, 2005 10:50AM
1464
December 12, 2005 05:14AM
1394
December 13, 2005 03:16AM
1534
December 14, 2005 11:17PM
1497
December 16, 2005 11:46AM
Re: Slower machine 100's of times faster??
1391
December 21, 2005 09:21AM
1423
December 26, 2005 08:32PM
1412
December 14, 2005 10:47PM
1427
December 23, 2005 12:29PM


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.