SQLite Forum

Best order to vaccum, analyze, create indexes, etc.. ?
Login
If the inserts are all in-order it will not make a lot of difference since not a lot of pages will be required to keep the entire changeset in the application LRU cache.

I found the sweet spot where the management overhead of cache pages outweighs the benefit derived from that cache at somewhere around a quarter of a million pages.  YMMV.