On 18 Dec 2017, at 2:48pm, curmudgeon <tam118...@hotmail.com> wrote:
> You're definitely right about me wasting my time Simon. I loaded my entire > database (1 GB) into memory and set cache_size = -8192 for an 8 GB cache > size (using win64). I then ran my test (inserting the results of a query, > returning 111 million bigints, into a non-indexed single column table) and > there was no real difference. For lesser inserts (2 million) the speedup was > around 33% but would hardly be noticeable to the end user. I’m glad you figured it out. Speed optimization for random hardware is hard and I’m glad I don’t have to do it. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users