RE: [sqlite] VB wrappers

2006-12-23 Thread RB Smissaert
TECTED] 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 transactio

Re: [sqlite] VB wrappers

2006-12-23 Thread Kees Nuyt
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 wh

RE: [sqlite] VB wrappers

2006-12-23 Thread RB Smissaert
ny 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 lo

[sqlite] VB wrappers

2006-12-23 Thread RB Smissaert
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 TerraInformati