RE: [sqlite] VB wrappers
> 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 -, 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] -
Re: [sqlite] VB wrappers
tOn Sat, 23 Dec 2006 20:55:16 -, 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] -
RE: [sqlite] VB wrappers
Have come to the conclusion that the only thing that is really import in speeding up SQLite inserts is to wrap it in a transaction. Things like: PRAGMA synchronous = OFF; PRAGMA encoding='UTF-8'; PRAGMA page_size=4096 or whatever number Don't seem to make a difference. Are there any other things that could speed up inserts? RBS -Original Message- From: RB Smissaert [mailto:[EMAIL PROTECTED] Sent: 23 December 2006 20:05 To: sqlite-users@sqlite.org Subject: [sqlite] VB wrappers Found this site: http://www.tannertech.net/sqlite3vb/index.htm#make_dll_vb_compat which looks like a nice tutorial about making a VB compatible wrapper. Had a go with the ready made dll and it all looks to be working nicely and Perhaps slightly faster than the commercial wrapper from TerraInformatica I use at the moment. Just wondering now (I know too late) if there is any benefit in commercial wrappers. They have a lot of interesting looking methods, but it looks all or most can be done with the 7 declares of the dll >From the above site. For example I have a method BeginTrans, but I can just issue the command BEGIN TRANSACTION and I think that will do the same. Is there any site that discusses the pro's and con's of the different ways to connect to SQLite? RBS - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] VB wrappers
Found this site: http://www.tannertech.net/sqlite3vb/index.htm#make_dll_vb_compat which looks like a nice tutorial about making a VB compatible wrapper. Had a go with the ready made dll and it all looks to be working nicely and Perhaps slightly faster than the commercial wrapper from TerraInformatica I use at the moment. Just wondering now (I know too late) if there is any benefit in commercial wrappers. They have a lot of interesting looking methods, but it looks all or most can be done with the 7 declares of the dll >From the above site. For example I have a method BeginTrans, but I can just issue the command BEGIN TRANSACTION and I think that will do the same. Is there any site that discusses the pro's and con's of the different ways to connect to SQLite? RBS - To unsubscribe, send email to [EMAIL PROTECTED] -