MySQL Forums
Forum List  »  MyISAM

How to improve performance of INSERT/UPDATE queries
Posted by: Niranjan Chalikonda
Date: January 06, 2012 03:49AM

I have a master table (having 75 columns + 1 column as primary key) with 6+ million rows of data and I need to do a data updates/inserts on a periodic basis into this table from a temporary table having the similar structure that of master table containing around 50000 rows.

At present, data updates is taking very long time to complete when i try to update 75 columns data from temporary table into master table where as data inserts (new records) is completed with in 1minutes.

Is there anything i need to do to improve the performance in this case? Kindly advise me the tips to follow as i am new to MySql environment.


Options: ReplyQuote

Written By
How to improve performance of INSERT/UPDATE queries
January 06, 2012 03:49AM

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.