Hi Ron, It may be that increasing the sqlite cache size will substantially reduce the time for either the CREATE INDEX or the SELECT ... ORDER BY.... instructions (depending upon which method you choose).
https://sqlite.org/pragma.html#pragma_cache_size On Wed, Sep 27, 2017 at 1:58 AM, jungle Boogie <jungleboog...@gmail.com> wrote: > Hi there, > > Just because I'm interested, I'm wondering if you can identify your > hardware, and how long it takes your system to do your desired operation on > such a large number of records. > > Do let us know which option you performed the query with as well. > > P.S. For best results, I'd recommend using the latest release of SQLite. > > Thanks! > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users