On Wed, Feb 15, 2012 at 20:33, Gabriel Biberian
wrote:
> Currently, i use the following query to update the filesystem table with the
> missing files :
> UPDATE filesystem SET dead=some_value WHERE dead=0 AND (SELECT 1 FROM
> temporary AS t WHERE t.hash=filesystem.hash LIMIT 1) IS NULL
I don't kn
Hello,
I'm working on a system that detects changes in someone's filesystem.
We first scan the entire filesystem which is dumped into the table
'filesystem' containing the full_path of every file and it's
corresponding md5 hash.
We then do subsequent scans of the filesystem which are dumped int