Thanks to all for suggestions. > My guesses: > - Your unix_time values are not successive. In this case your first fast > results are due to advantages of memory caching. The following slowness is > the result of the internal fragmentation
All unix_time values should be successive, but in the particular file used to create the inserts I discovered some corruptions in one area, random isolated bytes had been replaced with garbage, including bits of the timestamps, so this was the cause. Thanks for getting me on the right track! -- Steinar _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
