[horde] old horde_vfs entries - delete?

Matus UHLAR - fantomas uhlar at fantomas.sk
Tue May 3 13:04:45 UTC 2011


> 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?

-- 
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.
Spam = (S)tupid (P)eople's (A)dvertising (M)ethod


More information about the horde mailing list