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.

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
How to improve performance of INSERT/UPDATE queries
4171
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.