Re: Transaction Logging

From: "Jordan Bruce" <jbruce@asaglobalserv.com> > >I understand locking locking and concurrency (with isolation levels) but I >was hoping to get a clearer understanding on performance and functionality. Could you be a little less specific, please? >----------------------------------------------------- > >"Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message >news:8lmfja$o97$1@news.xmission.com... > > > > From: "Jordan Bruce" <jbruce@asaglobalserv.com> > > > > > >Hi and thank you in advance > > > > I was going to say something about "pleasure in arrears", but I'm scared >of > > what Carlos would say. > > > > >I have a couple of questions > > >1) How much does transaction logging affect speed > > > > Depends. It definitely does, buffered logging less than unbuffered >logging, > > but there is no formula to calculate this. ANSI is a nightmare. > > > > >2) Transaction Services/Scoping (this works together with the >transaction > > >logging and how transactions are started, committed or rolled back, if > > >there > > >is no logical transaction then what does Informix assume is a logical > > >transaction) > > > > Every SQL statement gets treated as a separate transaction. > > > > >3) Locking (what is this and how should it be used in the applications) > > > > "What is this"? You don't know what locking is? > > http://www.informix.com/answers/ > > ________________________________________________________________________ > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > > > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com