MySQL Forums
Forum List  »  Newbie

Re: Update Speed problem
Posted by: Rick James
Date: April 02, 2009 12:43AM

Sounds like update_category needs
INDEX (sku)

Without that, it has to do about 4.9 billion (700K*700K) operations. Don't even think about how much work it would take with 10M rows!

Actually, it would probably run faster if update_category had
INDEX (sku, category)
Then it only needs to look in the index.

Options: ReplyQuote


Subject
Written By
Posted
March 31, 2009 04:29PM
Re: Update Speed problem
April 02, 2009 12:43AM


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.