It is indeed windows Ryan and at times we’re talking 120 secs versus 30 + 14. This is related to the thread
http://sqlite.1065341.n5.nabble.com/This-is-driving-me-nuts-td102034.html or at least the latter part of it. I’m currently working on a repeatable shell demonstration to show how bad a light it shows sqlite in. ________________________________ From: sqlite-users <[email protected]> on behalf of R Smith <[email protected]> Sent: Thursday, June 14, 2018 10:34:58 AM To: [email protected] Subject: Re: [sqlite] .timer On 2018/06/14 10:28 AM, x wrote: > Thanks for the detail Simon. I’m consistently getting some really big > differences where user + sys < real. I’ll post another thread on it but it > does seem to be something windows is doing rather than sqlite. If sys + user << real - you are probably running Windows. :) On a more serious note, if I may - how big are those "big differences" and on which OS and media and what kind(s) of query? _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

