Subject Re: Read_commited
Author Alexander V.Nevsky
--- In IBDI@y..., David Jencks <davidjencks@e...> wrote:
> Hi,
> I have no idea what development environment you are in, however
leaving a
> transaction open for any length of time is almost always a terrible

Hi, David. I often here it, but can't see in my own practice. My
application starts read only read commited transaction on loading an
all day almost all select are done in this transaction. All changes
and additional short selects around changes are made in short snapshot
transactions. I have 15 active users and about 20 read-only ones.
Dayli they perform about 30 000 transactions, sweep is turned off and
performed at night by cron to normalize OIT. I really can't see any
performance degradation. Can you explain what is wrong with such
application structure?

Best regards.