GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Running query to update million records in the table - best way

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Running query to update million records in the table - best way

    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

  • #2
    Is it MyISAM or Innodb ?

    I would first think if you really need to do it as it sounds nasty and would not scale well.

    When you need to get table into memory and make sure update is well indexed and amount of extra indexes is kept to minimum.

    Comment

    Working...
    X