Re: When to Commit?

Mark D Powell wrote:

> Ed, where did I ever state that you commit within a logical
> transaction? Sybrands comment that you never have an intermediate
> commit was in response to where I stated that you pick a commit
> frequency within a job task based on the concurrent demand for the rows
> involved. Perhaps because I did not explicitly state that the commit
> should be between logical units of work, that is, a transaction which I
> think is a given, Sybrand misunderstood me. Nevertheless I think my
> post was pretty clear that I was talking about committing within a job
> and his response reads that you should commit only once.
>
> -- Mark D Powell --
>

You are right. It was the theoretical comment I objected to, and in doing so I misrepresented that part of your comments.

I offer a big SORRY.

-- 
Ed Prochak
running    http://www.faqs.org/faqs/running-faq/
netiquette http://www.psg.com/emily.html
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost