INSERT IGNORE vs INSERT REPLACE ? or something like this. If push notification comes in later and we already stored the “real” full message in the right sort order, the overwrite just makes it worse not better.
INSERT IGNORE vs INSERT REPLACE ? or something like this. If push notification comes in later and we already stored the “real” full message in the right sort order, the overwrite just makes it worse not better.