> I agree. My question is, what do you do when the size of that unit of
> work exceeds the capacity of the DB to handle it as a single
> transaction?

Firebird does not have such limit like
"capacity of the DB to handle it as a single transaction".
Sometimes single sql statement (that does lot of updates)
can use lot of RAM, but that's all.

Ivan