Re: Re[2]: [sqlite] how can i speed up inserts ?

2007-02-07 Thread Guillaume Fougnies
Wed, Feb 07, 2007 at 07:36:10PM +0200: DragonK wrote: > On 2/7/07, Teg <[EMAIL PROTECTED]> wrote: > > > >Hello ohadp, > > > >Well, my experience is, particularly when it's users using it and not > >a personal project, that corruption happens fairly frequently when you > >use this pragma. That's

Re: Re[2]: [sqlite] how can i speed up inserts ?

2007-02-07 Thread DragonK
On 2/7/07, Ken <[EMAIL PROTECTED]> wrote: Try without the pragma and wrap the inserts with a begin transaction and a commit... The performance will be almost as good as with the pragma, with the added benefit of consistent data and no corruption in the event of a crash or power failure. I

Re: Re[2]: [sqlite] how can i speed up inserts ?

2007-02-07 Thread Ken
Try without the pragma and wrap the inserts with a begin transaction and a commit... The performance will be almost as good as with the pragma, with the added benefit of consistent data and no corruption in the event of a crash or power failure. DragonK <[EMAIL PROTECTED]> wrote:

Re: Re[2]: [sqlite] how can i speed up inserts ?

2007-02-07 Thread DragonK
On 2/7/07, Teg <[EMAIL PROTECTED]> wrote: Hello ohadp, Well, my experience is, particularly when it's users using it and not a personal project, that corruption happens fairly frequently when you use this pragma. That's why I don't use it any more in my production code. Transactions are far

Re[2]: [sqlite] how can i speed up inserts ?

2007-02-07 Thread Teg
Hello ohadp, Well, my experience is, particularly when it's users using it and not a personal project, that corruption happens fairly frequently when you use this pragma. That's why I don't use it any more in my production code. Transactions are far safer and fast too. C Wednesday, February 7,