On Wed, Feb 04, 2009 at 10:10:15PM -0700, Gerry Snyder scratched on the wall: > pri...@gmail.com wrote: > > Yes, there are 3 indexes being created.... > > > > I'll post again after figuring out which of the changes improved the > > performance. Thanks for the clues! > > Since you are able to do some experimenting, try entering the data > without the indices, and then create them.
Generally, this won't make a huge difference. It is more or less the same as doing all the inserts in one commit. Dealing with sorting that much data all at once can actually be slower. What will make the biggest difference is how much memory you have available. As you noticed, part of that is page size, but a big part is also the size of the page cache. The default settings are 1K pages w/ 2000 page cache. Each page in the cache has ~0.5K overhead, so that's a 3MB cache. If you're doing this on a beefy desktop with the default 1K pages, crank the cache up to 100,000 pages or more. Adjust accordingly for larger pages. -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
