Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

UPDATE vs. INSERT speed

Status
Not open for further replies.
gdj

gdj

Programmer
Dec 14, 1999
1
0
0
US
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 rows/second<br>
UPDATE: 60 rows/second<br>
<br>
The table in question had two indexes, one of them unique. Is there a way to improve the UPDATE performance?<br>

 
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question
Update column based on input from another column 3
Replies
6
Views
112
penguinspeaks
penguinspeaks
TOPBAY
  • Locked
  • Question
MariaDB10 vs MariaDB5
Replies
0
Views
36
TOPBAY
TOPBAY
dylim
  • Locked
  • Question
Why MySQL 5.7 is still getting updates
Replies
3
Views
84
spamjim
spamjim
BJZeak
  • Locked
  • Question
need help with .sql insert statement
Replies
1
Views
45
spamjim
spamjim
benderulz
  • Locked
  • Question
After Update Trigger?
Replies
1
Views
35
majlumbo
majlumbo

Part and Inventory Search

Sponsor

Back
Top