Relative Content

Tag Archive for pythonhash

How and Where to store hashe keys for better performance comparison

I once in a while (~ every 15 days) i receive a snapshot of a DB let say MySQL.
Each snapshot contain all the rows that were in snapshot – 1 plus the new ones.
Also rows can be updated after they were inserted.
i want an effective way to find the diff between snapshot_N and snapshot_N-1.
meaning finding the new rows and the ones that have been updated.