> following through this thread and I agree it is a programming error > causing a waste of resources. But I am confused as to why this is a > problem for Firebird. I thought that lots of short transactions was > actually something to be encouraged over long running transactions. Is > there some limit to # of transactions / time period? > The installation was using Firebird 2.5.2 SC. There was near 800000 transactions/day, more than a half between 8:00 AM and 15:00PM.
The system runs fine and the performance was good except the problems of page conversion, some minutes the System was frozen (10 minutes) at 9:30 AM, and the crash i had deleting one attachment. 1. The frozen may be because a sweep was executed. I had sweep interval set to 20000. Now is disabled and executed at night. 2. The page conversion, i think is solved, when we corrected the overhead generated by the transactions. 3. The crash deleting the attachment, is complicated to reproduce now, because I think the source is the amount of transactions. I'm worried with this one, because I don't like engine crash. May be this amount of transactions is not good for Firebird. Regards, jesus [Non-text portions of this message have been removed]
