[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