Skip directly to content

SQL Java

Upserts in VoltDB

Friday, November 16, 2012 - 12:00am

written by Andrew Wilson 

 

The idea behind an upsert is that you try an update or an insert query first and if it fails, you then do the other query.

Why do an upsert? Upserts tend to be very fast in traditional databases because they can execute in as little as one query or as many as two. Consequently, a good upsert strategy has only two defined queries (insert and update) rather than three (insert, update and select). More importantly, “upsert” itself can be a keyword in which the database understands that it is responsible for figuring out whether to update or insert a record.