On 14 Jun 2018, at 9:28am, x <[email protected]> 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.
You're welcome. It's barely worth the post here. SQLite has some control over 'user' and 'sys' but none over 'real'. If your 'real' got too big, Windows is doing an update, or indexing files, or defragging a hard disk or something. I've seen a badly-written printer driver which checked ink levels every 5 seconds instead of the intended 5 minutes. That's the sort of thing that gives you bbd 'real' times. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
