[horde] old horde_vfs entries - delete?

Matus UHLAR - fantomas uhlar at fantomas.sk
Thu Apr 21 09:14:57 UTC 2011


I have a big horde_vfs table.
I see that some entries are years old, at least the vfs_modified says so.

According to some scripts I looked into, the vfs_modified is changed every
time the file is updated, so those old entries were put theer long time ago.

Is it ok to clean the old data from horde_vfs?
If so, should I just run

delete from horde_vfs where vfs_modified < unix_timestamp(date_sub(now(), interval 1 day));

Matus UHLAR - fantomas, uhlar at fantomas.sk ; http://www.fantomas.sk/
Warning: I wish NOT to receive e-mail advertising to this address.
Varovanie: na tuto adresu chcem NEDOSTAVAT akukolvek reklamnu postu.
Remember half the people you know are below average. 

More information about the horde mailing list