Using the MySQL C API, execution of an UPDATE appears to be about 10 times slower than an INSERT. Running under UNIX on an UltraSPARC 20, I got these results:<br>
<br>
INSERT (with 100 value sets per statement): 2500 rows/second<br>
INSERT (with 1 value set per statement): 600...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.