Feature Suggestion: Reusing old RIDs

[ghost]

RIDs are never recycled and this leads to lots of disk space usage.

Perhaps there could be a system index for each cluster with all orphaned RIDs (so OrientDB doesn't have to loop through all records to find if a previous one is empty) and new records would use any available spots, if none are available, create record as per normal.

[andrii0lomakin]

Hi. I think that your problem is not reused RIDs, but " lots of disk space usage". Is it correct. If you wish this problem to be fixed please vote on orientechnologies/orientdb-labs#7 . One of its goals "Reuse space which is used to store rid of delete record" .

[ghost]

Wouldn't it be more efficient to reuse the RIDs? Especially with pagination?

[andrii0lomakin]

It leads to the case when you fetch records which are already removed. I sent stale link or have such one in application and all the sudden it appears again , we have received a lot of complaints from users when once made rids reusable.

[ghost]

Alrighty, I'll go vote on the other thread you linked.