> > 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). >
I forgot to mention I use JDBC to access sqlite from a java app. Is there an equivalent line of code to execute from within java/jdbc to do the same thing? Or a configuration somewhere? On Wed, Oct 29, 2008 at 7:53 AM, Jay A. Kreibich <[EMAIL PROTECTED]> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
