Tickets :: Comment on [#4797] A large horde_vfs table can cause large memory usage during GC

* Your Email Address
* Spam protection	Enter the letters below: . . __.. . .. . \ /(__ \| \|_/ \| \| \/ .__)\|___\| \\|__\|
Comment	> Okay, can you give this implementation a shot? Drop this into VFS_sql: > > > > /** > > * Garbage collect files in the VFS storage system. > > * > > * @param string $path The VFS path to clean. > > * @param integer $secs The minimum amount of time (in seconds) required > > * before a file is removed. > > */ > > function gc($path, $secs = 345600) > > { > > $sql = 'DELETE FROM ' . $this->_params['table'] > > . ' WHERE vfs_type = ? AND vfs_modified < ? AND (vfs_path > = ? OR vfs_path LIKE ?)'; > > $this->log($sql, PEAR_LOG_DEBUG); > > > > $values = array(VFS_FILE, > > time() - $secs, > > $this->_convertPath($path), > > $this->_convertPath($path) . '/%'); > > > > return $this->_write_db->query($sql, $values); > > } > > > > ... and use it with the latest version of GC.php > (http://cvs.horde.org/framework/VFS/VFS/GC.php - it'll call a gc() > method if it exists in the passed-in $vfs object).
Attachment
Watch this ticket