First off I apologize if this is question has been beaten to death. I've looked around for a simple answer and could not find one.Given a database that will not have it's PKEY or indices modified, is it generally faster to INSERT or UPDATE data. And if there is a performance difference is it substantial?
This seems odd. If you have an option to update but choose to insert what becomes of the other record?
