Re[2]: [firebird-support] OIT / NT
Hello, Tiberiu! Monday, April 2, 2012, 10:33:43 AM, you wrote: TH should I use TACommit as default action for TIBTransaction ? TH object trans: TIBTransaction TH DefaultDatabase = database TH DefaultAction = TACommitRetaining DefaultAction how to end transaction, when IdleTimer is out (and greater than 0). Also DefaultAction defines how active transaction will end when IBDatabase is being closed. So, DefaultAction = taCommitRetaining - is really nonsense. It must be taCommit or taRollback. And better is - taRollback due to logic I described above. What you need, is to set AllowAutoStart=False for all transactions you have. Have you tried to read translated www.ibase.ru/devinfo/ibx.htm ? Seems no. -- Dmitry Kuzmenko, www.ib-aid.com
Re: Re[2]: [firebird-support] OIT / NT
Thank you for your time ... I will do some serious reading and testing ! Tiberiu From: Dmitry Kuzmenko Sent: Monday, April 02, 2012 10:03 PM To: firebird-support@yahoogroups.com Subject: Re[2]: [firebird-support] OIT / NT [Non-text portions of this message have been removed]
Re[2]: [firebird-support] OIT / NT
Hello, Jesus and Tiberiu! JG O don't know If is firebird or not but i have had the same JG problem wiith ibx+delphi+interbase 2009. I have had jumps of 2 transactions, and of course JG is imposible by the kind of our app generate 2 transactions JG in seconds. I have observes it, but I have not been able To reproduce it . TH At least I'm not alone . Sorry guys, I don't believe in magic or some spy applications, that suddenly generates lot of transactions. One of the cases like that, when some application started to generate millions transaction per day, was the programmer's fault, when he forgot to construct web page content from the database in one transation. Instead, his code produced start/commit at each web page element, and there were lot of elements. So, this is just the result of bad transaction control in application. Teberiu, some you answers goes somehow not to this list, because field From does not contain anything. In your example you named lot of IBX components, nearly all of them except IBTransaction. Do you really NOT using it? TH couldn't this problem be because of a failure in some hardware component ? TH or the FIBClient is not properly installed ? NO. I say second time - nothing except you or your application is generating these transaction. Firebird (or fbclient) have no interest in data, transactions or even databases, and it does not do anything by itself. I can suggest you to read Helen's book about Firebird. And, about IBX - try to read my article with some translation from russian. You need to translate and read everything about IBTransaction component and the section about how to work with transactions in this document: http://www.ibase.ru/devinfo/ibx.htm or with translation http://translate.google.com/translate?sl=rutl=enjs=nprev=_thl=ruie=UTF-8layout=2eotf=1u=http%3A%2F%2Fwww.ibase.ru%2Fdevinfo%2Fibx.htmact=url Unfortunately google translates only part of the document. So, you will need to translate it by parts. -- Dmitry Kuzmenko, www.ib-aid.com
Re: Re[2]: [firebird-support] OIT / NT
Sorry guys, I don't believe in magic or some spy applications, that suddenly generates lot of transactions. One of the cases like that, when some application started to generate millions transaction per day, was the programmer's fault, when he forgot to construct web page content from the database in one transation. Instead, his code produced start/commit at each web page element, and there were lot of elements. So, this is just the result of bad transaction control in application. I also don't belive in magic, when talking about computer science, but is not a programmer error. I have to say that i have seen it after backup and restore cycle. Just starting to work our customers with the application, i saw jumps of a big number of transactions. In my case we control the transactions in all the application, and active/desactive them when we need it. I have not seen that behaviour with firebird, but with Interbase 2009 yes. I thought it was a bug, like others in IB, and i could not reproduce it. Regards, Jesus [Non-text portions of this message have been removed]