In SQL, is UPDATE always faster than DELETE+INSERT?

by

A bit too late with this answer, but since I faced a similar question, I made a test with JMeter and a MySQL server on same machine, where I have used:

  1. A transaction Controller (generating parent sample) that contained two JDBC Requests: a Delete and an Insert statement
  2. A sepparate JDBC Request containing the Update statement.

After running the test for 500 loops, I have obtained the following results:

DEL + INSERT – Average: 62ms

Update – Average: 30ms

Results:
Results

More Related Contents:

  1. How to delete duplicate rows in SQL Server?
  2. Best way to do multi-row insert in Oracle?
  3. How can I delete using INNER JOIN with SQL Server?
  4. How to insert a value that contains an apostrophe (single quote)?
  5. How to speed up insertion performance in PostgreSQL
  6. How to delete duplicate entries?
  7. Avoid duplicates in INSERT INTO SELECT query in SQL Server
  8. Insert data in 3 tables at a time using Postgres
  9. SQL Error: ORA-01861: literal does not match format string 01861
  10. Best way to delete millions of rows by ID
  11. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  12. How to efficiently delete rows while NOT using Truncate Table in a 500,000+ rows table
  13. How to delete the top 1000 rows from a table using Sql Server 2008?
  14. INSERT COMMAND :: ERROR: column “value” does not exist
  15. How to delete in MS Access when using JOIN’s?
  16. Generate DEFAULT values in a CTE UPSERT using PostgreSQL 9.3
  17. “column not allowed here” error in INSERT statement
  18. Case statement for multiple columns
  19. Transaction lock in sql
  20. Is a view faster than a simple query?
  21. How to get matching data from another SQL table for two different columns: Inner Join and/or Union?
  22. SQL SELECT WHERE field contains words
  23. Date Difference between consecutive rows
  24. What does Include() do in LINQ?
  25. ORA 00904 Error:Invalid Identifier
  26. Unfindable SQLite Syntax Error
  27. Inserting into Oracle and retrieving the generated sequence ID
  28. Converting String List into Int List in SQL
  29. What is the most appropriate data type for storing an IP address in SQL server? [duplicate]
  30. How to bulk insert only new rows in PostreSQL

Leave a Comment