Transaction Logging

Posted in 2000

Topics: Transactions, Locking & Isolation

Jordan Bruce — Wed, 26 Jul 2000 02:58:34 GMT — source: Informix-list mailing list archive (1991-1998)

Hi and thank you in advance I have a couple of questions 1) How much does transaction logging affect speed 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) 3) Locking (what is this and how should it be used in the applications) Again thank you in advance for helping Jordan Bruce jbruce@asaglobalserv.com -- -----------------------------------------------------

↪ replying to Jordan Bruce

Art S. Kagel — Wed, 26 Jul 2000 12:25:09 -0400 — source: Informix-list mailing list archive (1991-1998)

Jordan Bruce wrote: > > Hi and thank you in advance > > I have a couple of questions > 1) How much does transaction logging affect speed The answer is that the effect is irrelevant. If I told an Indy driver he could get near perfect traction and be able to power through every corner with the new "Gummy2000" tires and they will wear for an entire race eliminating at least one Pit Stop or reducing its length, I doubt he would care how much it will slow him down to use them unless the result were outragious. Let me reassure you the advantages clearly and completely outweigh the costs when it comes to turning on logging. Don't even consider not logging your database unless you have not updates and replace the whole thing, ala DW, weekly. Even then I'd consider logging the database. > 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) Singleton SQL statements outside of any transaction are treated as self contained transactions which are committed or rolled back depending on results. > 3) Locking (what is this and how should it be used in the applications) What about it. Row and index locking is automatic and controlled by Isolation Levels and operation type. Table and database locking are mainly for maintenance as they prevent concurrent access. What else do you need to know. Art S. Kagel