MySQL Forums
Forum List  »  Optimizer & Parser

Performing multiple updates and selects
Posted by: Kristian Schmidt
Date: March 06, 2009 05:56AM

Using MySQL 5 with MyISAM.

I have 15+ tables, a few of them with 1.000.000+ rows. These tables are on two different databases on the same machine.

I am performing a (yearly) update job which does a lot of updates on these tables and this took 12 hours+ on the (slow) test machine.

I locked all the tables with WRITE locks before starting.

Is there a performance gain by doing all the updates on one table at the time? Now I do one (type of) update on all tables (on both databases), then move on to the next type of update.

Options: ReplyQuote

Written By
Performing multiple updates and selects
March 06, 2009 05:56AM

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.