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?
Consider the two pseudo-schemas, I'm just making this up for example purposes:
aMealId = INSERT INTO meal_event(user_id, started) VALUES (aUserId, NOW());
When preparation starts:
UPDATE meal_event SET prepared = NOW() WHERE id = aMealId;
And so on.
Basically the same data, in one case you always do inserts and add new tables for new events. In the other case you only insert once and then update for each state, then you add columns if you have new states.
As I said this is just an example. But in SCHEMA A you have only inserts, lots of tables and in SCHEMA B you have a lot of updates and a lot of possibly NULL columns if certain events don't occur.
