> 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]