On 10 Sep 2019, at 4:02pm, mailing lists <mailingli...@skywind.eu> wrote:
> Insertion really slows down after about 100 000 items have been inserted. I > suppose that the slow down is related to indexing because: > > [...] > c) changing the cache size has only a minor impact SQLite speed does degrade with table size, but it degrades gracefully. Depending on which OS you're using, you have at least three caches in play. A sudden change in speed indicates that you just bust one of those caches, as you wrote. But in this case it's probably the OS's memory cache assigned to your program. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
