count deldted records fast

[bdenson]

Is there a quick way of counting deleted records?

I am using COUNT FOR DELETED() TO deletedcnt at the moment, but it is too slow on large files.

Also, what functions are available to provide statistics about a table, i.e number of records, file modification dates, record size etc

(the ones I have listed are the ones I have manage to do, but I've given them as examples of the sort of stats I want).

Thanks

Barry

 

[csr]

Well, it might be quicker if you had a tag (index) which indexed on deleted(). Then maybe RUSHMORE would take over.
You could look into that.

Other than that, if you absolutely have to have the information instantly you will have to keep track of that statistic in a separate file somewhere and keep updating it each time you delete/recall a record. Of course, this introduces possible error. So, you might have to update these figures during off hours to keep it as close as possible, etc ...

It just depends on how important this is to you.

Don
dond@csrinc.com