[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