Sorry folks, this article was based on flawed benchmark results, I will soon post an update!
Please goto:
Imported comments
These were imported from my old blog. Please use disqus below for new comments
Mohammad Shiblee
on 2011-01-29 16:14:48
Hi,
How can improve update performance in mysql.
Actually in my mysql-table there are approx 100000 records and i want to update all the records at once.
Kevin
on 2009-04-03 10:57:53
@ Thijs &
amp; feedreader: Lucky me. I was able to mess up my bench results only to find an even faster method :)
http://kevin.vanzonneveld.net/techblog/article/improve_mysql_insert_performance/
2100% instead of 1200% ;)
Thijs
on 2009-03-31 12:06:06
Thanks alot! This was very helpfull and helped me to clean alot of my code!
feedreader
on 2009-03-31 07:38:08
Very interesting. I wish I had read this 3 months ago :(