Re: [sqlite] COMMIT versus END

2005-03-11 Thread Keith Herold
Right; I was thinking of checkpoint stuff, in a sense. Smaller transactions make things waaay slower :) . --Keith On Fri, 11 Mar 2005 14:03:45 -0500 (EST), Clay Dowling <[EMAIL PROTECTED]> wrote: > > Keith Herold said: > > I have a batch process that commits sets of 25 pre-built sql scripts >

Re: [sqlite] COMMIT versus END

2005-03-11 Thread D. Richard Hipp
On Fri, 2005-03-11 at 10:20 -0800, Keith Herold wrote: > Is there a difference between COMMIT and END TRANSACTION ? > > I have a batch process that commits sets of 25 pre-built sql scripts > on a timed basis. I have been wrapping the execution of all 25 sets > in a single begin...end transaction

[sqlite] COMMIT versus END

2005-03-11 Thread Keith Herold
Is there a difference between COMMIT and END TRANSACTION ? I have a batch process that commits sets of 25 pre-built sql scripts on a timed basis. I have been wrapping the execution of all 25 sets in a single begin...end transaction set. The problem is that if any of those scripts fails to