Re: Performance degradation question w/transactions

Nils Myklebust wrote: > > Roger Tomas <tomasr@agcs.com> wrote: > > :John Cowles wrote: > :> > :> Test 1: > :> ------- << snip >><< snip >> << snip >><< snip >> > > "without transactions" means there are no transactions at all. In the > last test each sql statement is it's own "transaction", but nothing is > written to the log for these statements, so this would obviously be > much faster. This may be dangerous, but very usefull for many > purposes. Nothing is written to the log only when the database does not use 'logging'. Otherwise, every insert/update/delete is logged, whether it is wrapped in a begin work/commit work statements or not. At least, this is what I have been thinking informix does, any comments? > > Nils.Myklebust@idg.no > NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway > My opinions are those of my company > The Informix FAQ is at http://www.iiug.org -- \\\\|// Vijay R. Anisetti |6 6| -------------------oooO--U--Oooo---------------------------- oooO Oooo ( ) ( ) Just hangin on to this profession ---------------\\( -- )/------------------------------------- \\) (/