The Slippery Slope, Smaller Transactions = Uglier Code?

Everywhere I turn, I am reducing my transaction size and shortening my query duration. I am doing this to minimize the roll back segment size and to avoid the data too old error. But each step, makes my code uglier. Simple high level relational commands start looking like procedure code.

Am I missing something? Or is this a classic design process, where optimizing one ideal compromises another.

TIA scott Received on Sun Jun 21 1998 - 22:43:04 CDT