We would like to add to records start and end timestamp fields. When end field is null, it indicates the last version of this item.
Few questions:
- in terms of performance, what would be faster, having a single timestamp and looking for the top1 when ordered by time or the above solution, looking for null end field?
- If using end field, would an index matter?
- what is the best way to intercept the update operation, clone the object, update the old one (if end field is used) and save the clone object as new?
- What is the recommended way for creating a UUID PK?
Avishay Ben Natan