> PRAGMA cache_size > PRAGMA default_cache_size Thanks, will experiment with those. My bytes per row are small, but the number of rows to insert can be large, up to a few million, although typically up to a few 100.000.
RBS -----Original Message----- From: Kees Nuyt [mailto:[EMAIL PROTECTED] Sent: 23 December 2006 21:41 To: sqlite-users@sqlite.org Subject: Re: [sqlite] VB wrappers tOn Sat, 23 Dec 2006 20:55:16 -0000, you wrote: >Have come to the conclusion that the only thing that is >really important in speeding up SQLite inserts is to wrap >it in a transaction. Yes, it is. >Things like: >PRAGMA synchronous = OFF; >PRAGMA encoding='UTF-8'; >PRAGMA page_size=4096 or whatever number >Don't seem to make a difference. page_size is important when you have many bytes per row, think of blobs or long texts. Also when you have very many rows, as the maximum number of pages is not endless. >Are there any other things that could speed up inserts? > >RBS PRAGMA cache_size PRAGMA default_cache_size especially when you are building large indexes. -- ( Kees Nuyt ) c[_] ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------