Here's the screenshot showing the resource usage of the slow query:
>time ./sqlite3.3.8.exe db.sqlite "SELECT * FROM files where id < 200000 ORDER BY size, name;"|wc 199999 204598 24676875 real 4m49.947s user 0m18.386s sys 0m13.318s Peak memory 35 MB
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------