On Feb 2, 2010, at 2:33 PM, dsdreamer wrote:
>
> Code:
> --------------------
>
> # 3. Files that have changed mtime or size.
> # XXX can this query be optimized more?
> my $changedOnlySQL = qq{
> SELECT scanned_files.url
> FROM scanned_files
> JOIN tracks ON (
> scanned_files.url = tracks.url
> AND (
> scanned_files.timestamp !=
> tracks.timestamp
> OR
> scanned_files.filesize !=
> tracks.filesize
> )
> AND tracks.content_type != 'dir'
> )
> WHERE scanned_files.url LIKE '$basedir%'
> };
>
>
> --------------------
>
>
> Am I right? Anyone else see this behavior?
I'd be surprised, since this query is basically instant in SQLite. I will get
back to some MySQL testing in the next day or so, and see if I can spot any
problems.
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
