How to get least recently read records

As a part of cleanup process to reduce disk usage, I want to get all records which have not been read in the past one year and delete those. These records are getting updated frequently but since they are not read, they are of no use.

Can I get these record? Otherwise, it will be enough even if I get the set whose records haven’t been read over a fixed time period

Thanks.

If records are to be retrieved by access time, the application will have to implement a special scheme on its own. The databases only keeps tracks of Last Update Time (lut) for a record, but not Last Access (Read) Time. The application can explicitly update a “last-access-time” bin whenever the record is read, using the multi-bin operate API. Note, this does not apply to record reads through scans or queries.

Thanks a lot!

This topic was automatically closed 84 days after the last reply. New replies are no longer allowed.