On Wed, Oct 29, 2008 at 06:10:56AM -0600, John Stanton scratched on the wall:
> The Sqlite B-Tree indices do slow down on insertion as extra levels are > created in the index as it grows large. That is an inherent feature of > such structures. This can often be mitigated by increasing the size of the page cache. A large page cache will speed up the creation of new indexes considerably, especially for data that is not already sorted. A larger cache can also help with frequent inserts on existing indexes. See "PRAGMA cache_size". If you're working on a modern desktop with a comfortable amount of RAM, it isn't unreasonable to increase the cache size by an order of magnitude or two (default is 2000). -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Our opponent is an alien starship packed with atomic bombs. We have a protractor." "I'll go home and see if I can scrounge up a ruler and a piece of string." --from Anathem by Neal Stephenson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
