I am looking for best practices for deleting historical edges. I am following the approach of "end timestamp" approach to end the relationship. As per our use case, we need to delete linkages which are ended more than 7 years needs to be purged.
Our Initial thought process was,
1. Whenever we end the linkage by adding end timestamp , we thought of adding expiry (ttl)
(Note: But one of the documentation, I found that cannot be done. "DSE Graph sets TTL per vertex label or edge label, and all vertices or edges will be affected by the TTL setting. DSE Graph cannot set TTL for an individual vertex or edge.")
2. Have some cron job which triggered everyday to check the expiry and delete the edges. using gremlin traversal and invoke drop(). if this is a suggested approach then does it synchronous? is it possible to be done asynchronous way?
3. Any other approach?