126 reputation
14
bio website j-li.net
location Ottawa, Canada
age
visits member for 1 year, 8 months
seen Apr 20 at 19:50

"Java is to Javascript as Ham is to Hamster"

Website: j-li.net
Twitter: @pushrax


Oct
1
awarded  Notable Question
May
16
awarded  Popular Question
Apr
2
awarded  Supporter
Nov
7
comment What's the most efficient way to batch UPDATE queries in MySQL?
@AlainCollins using a temporary table would be faster then?
Nov
7
comment What's the most efficient way to batch UPDATE queries in MySQL?
@AlainCollins I'm doing the insert to batch a ton of updates into one database query. I'm asking if there's a better way to do that.
Nov
7
awarded  Student
Nov
7
awarded  Editor
Nov
7
revised What's the most efficient way to batch UPDATE queries in MySQL?
added 579 characters in body
Nov
7
comment What's the most efficient way to batch UPDATE queries in MySQL?
This is on a testing machine and not on production so InnoDB isn't completely tuned properly. I'm not totally sure about how INSERT FROM operates, but what you said seems about right. Updated the question with the info you asked for.
Nov
6
revised What's the most efficient way to batch UPDATE queries in MySQL?
edited tags
Nov
6
asked What's the most efficient way to batch UPDATE queries in MySQL?