Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » Running query to update million records in the table - best way
Running query to update million records in the table - best way [message #1576] Tue, 07 August 2007 02:19 Go to previous message
abhaygupta is currently offline abhaygupta
Messages: 1
Registered: August 2007
Location: India
Junior Member
Hi all,

I have a table with 6 fields. Index is implemented on 2 fields - ArticleId and CategoryId, which also form the composite primary key.

The table has more than a million records and we need to run updates on it every 10 minutes.

Please advice what is the best way to run an update query so it takes the least possible time.

Best regards,
Abhay Gupta
Report message to a moderator
[Message index]

Read Message
Read Message
Previous Topic:mysql performance
Next Topic:optimize help for order by
Goto Forum:

  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Fri Jul 10 02:20:44 EDT 2009

Total time taken to generate the page: 0.01550 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.