Re: Transaction Logging
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
I understand locking locking and concurrency (with isolation levels) but I was hoping to get a clearer understanding on performance and functionality. Thanks -- ----------------------------------------------------- "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 >