MySQL Forums
Forum List  »  MyISAM

Update Performance on large MyISAM tables
Posted by: Peter Crosbie
Date: January 23, 2005 03:44PM

I have several large tables, 5-6m records that I need to update from time with new calculated values. The SQL UPDATE does a select and then a write. This is very slow for 5m records even when the where clause is simple and indexed.

Is there a way to sequentially read and write to a MyISAM table?

Any other suggestions?

Options: ReplyQuote


Subject
Views
Written By
Posted
Update Performance on large MyISAM tables
4532
January 23, 2005 03:44PM


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.