Subject Re: [firebird-support] OIT / NT
Author Thomas Steinmaurer
>> Friday, March 30, 2012, 12:13:06 PM, you wrote:
>>
>> TH> which) somehow foods my server. While this client is using my
>> TH> software, somehow the gap between OIT and NT increases 200 transactions each 5 seconds. I
>>
>> Other people noted lot of things, but I want to ask - what do you do
>> in the application, that it generates 40 transactions per second?
>> I mean, it's some kind of robot, inserting bulk data, or it is a
>> human, typing data with non-human speed?
>>
>> Firebird does not generates transactions, so, all these transactions
>> are coming only from your application.
>>
>>
> O don't know If is firebird or not but i have had the same problem wiith ibx+delphi+interbase 2009. I have had jumps of 20000 transactions, and of course is imposible by the kind of our app generate 20000 transactions in seconds. I have observes it, but I have not been able To reproduce it .

Any chance that you guys are running something in a loop with AutoCommit
set to True?



--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/

Do you care about the future of Firebird? Join the Firebird Foundation:
http://www.firebirdsql.org/en/firebird-foundation/