[horde] old horde_vfs entries - delete?

Jan Schneider jan at horde.org
Tue Apr 26 10:39:17 UTC 2011


Zitat von Matus UHLAR - fantomas <uhlar at fantomas.sk>:

> Hello,
>
> 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));

Your users might be *very* unpleased if you deleted arbitrary files  
from the VFS just because they haven't been updated in a while.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/



More information about the horde mailing list