[horde] old horde_vfs entries - delete?

Jan Schneider jan at horde.org
Tue May 3 13:16:54 UTC 2011


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

>> Zitat von Matus UHLAR - fantomas <uhlar at fantomas.sk>:
>>> 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));
>
> On 26.04.11 12:39, Jan Schneider wrote:
>> Your users might be *very* unpleased if you deleted arbitrary files from
>> the VFS just because they haven't been updated in a while.
>
> "a while" like "a few years"?
>
> What kind of data are stored there btw?

All kind of data, linked attachments, contact attachments, user files etc.

Jan.

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



More information about the horde mailing list