Subject | Re: [ib-support] Deadlock and wait |
---|---|
Author | Woody |
Post date | 2001-07-26T15:17:56Z |
From: "Ann W. Harrison" <aharrison@...>
Sent: Thursday, July 26, 2001 10:03 AM
Subject: Re: [ib-support] Deadlock and wait
Delphi should be set to (Read Committed, No Wait, Record Version). I am
interested in why you say that Read Committed shouldn't be used. Most
opinions state that having this setting allows you to have an updated view
of data in a multi-user environment so that you are always working with the
latest version of the records in a table. Other than reports or static views
of data, why wouldn't you want it that way?
(Sorry if I missed a previous explanation)
Thanks,
Woody
Sent: Thursday, July 26, 2001 10:03 AM
Subject: Re: [ib-support] Deadlock and wait
>Ann, most newsgroups that I read have posts that say that transactions in
> In case there is anyone in the world who is unaware of it, I consider
> the read committed transaction mode one of the worst ideas of the last
> century. If you care (at all) about the consistency of data, shun it.
>
Delphi should be set to (Read Committed, No Wait, Record Version). I am
interested in why you say that Read Committed shouldn't be used. Most
opinions state that having this setting allows you to have an updated view
of data in a multi-user environment so that you are always working with the
latest version of the records in a table. Other than reports or static views
of data, why wouldn't you want it that way?
(Sorry if I missed a previous explanation)
Thanks,
Woody