I hope you can help me, I had an application, Is a messaging system and I would like to be able to do about 50000 updates every two seconds on a table indexed by autoincrement id.
What is the faster way to do these updates? Send these on the same query? disable the indexes?
Thanks in advance,