Hello fellow DBMAN Users,

Has anyone ever implemented a way to find out which records have been accessed the most in the Database. I have a bunch of records in the DB and want to know which ones are the most frequently looked at by the
users!

Please let me know how difficult a feat this would be to accomplish.

Thanks,
Roger

Without actually writing any code to do this, my theory would be to add an extra field to the database which would be an incremental number. This number would be incremented each time the record had been accessed. You could call this like &get_date gets called. You probably would be able to use a variation of the routine Alex coded for incrementing the ID number. The tricky part would be working this into the search routine so that it'd modify this field each time.

As to how easy or hard this would be I have no idea since I've never looked into doing this. As for creating statistics from this data, all you'd have to do is step through the database and do some counting and sorting.