Hi Radzi, i do it with BEGIN and COMMIT. it is that, even in this case for transaction support sqlite has to write into the journal files as well. i want to avoid this too.
Thanks, Rasanth On Dec 26, 2007 11:34 AM, Mohd Radzi Ibrahim <[EMAIL PROTECTED]> wrote: > On the contrary, sqlite work much-much faster when insert/update is > done within BEGIN and COMMIT; > > regards, > Radzi. > On 26-Dec-2007, at 12:14 PM, Rasanth Akali Kandoth wrote: > > > Hi All, > > I have an application which inserts large number of rows into a > > table, where > > transaction support is not necessary. For performance reason, i need > > to > > disable the transaction support in sqlite version 3.3.17 . How can > > i do > > it? any help is highly appreciated. > > > > -- > > Thanks, > > Rasanth > > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > > ----------------------------------------------------------------------------- > > -
