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
> >
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
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 execut
3 matches
Mail list logo