Re: [sqlite] Keeping ROWID for INSERT OR REPLACE

Neville Franks wrote: > I want to insert a row if its key clm doesn't exist otherwise update > it. I can search for the row and then do either an insert or update > accordingly. However I was wondering whether the SQLite Conflict > Resolution: INSERT OR REPLACE would be more efficient (faster).

[sqlite] Keeping ROWID for INSERT OR REPLACE

I want to insert a row if its key clm doesn't exist otherwise update it. I can search for the row and then do either an insert or update accordingly. However I was wondering whether the SQLite Conflict Resolution: INSERT OR REPLACE would be more efficient (faster). The problem is the REPLACE