[imp] SQL VFS for attachments
Didi Rieder
adrieder at sbox.tugraz.at
Mon Feb 17 20:38:41 PST 2003
Quoting Liam Hoekenga <liamr at umich.edu>:
> Just curious... when using a SQL based VFS backend for attachment storage, is
> there any sort of garbage collection to sweep table for orphaned files? (eg
> someone attaches a file to a message, and then never sends that message -
> like
> they quit their browser or it crashes, etc)
We do it with a cronjob wich executes the following sql-statement:
delete from horde_vfs where vfs_modified < UNIX_TIMESTAMP() - 7200;
Didi
--
-------------------------
Didi Rieder
adrieder at sbox.tugraz.at
PGPKey ID: 3431D0B0
-------------------------
More information about the imp
mailing list