How to improve performance of INSERT/UPDATE queries

[Niranjan Chalikonda]

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.