Durumdara wrote:
Please send me an example (pseudo-code) for Serializable conflict.
And I wanna know, if possible, that if more transactions only
read the tables in Serializable mode, and one or others write
to it, can I got some conflicts in read operation?
You get a serialization conflict
Hi!
Thanks for your help!
Another question if I use only SELECTS can I get some Serialization Error?
For example:
I need a report tool that can show the actual state of the business.
Because of I use value-dependent logic, I MUST use consistent state to
preserve the equality of many values
Hi durumdara,
On Tuesday 07 July 2009 12:10:52 durumdara wrote:
Another question if I use only SELECTS can I get some Serialization
Error?
No.
For example:
I need a report tool that can show the actual state of the business.
Because of I use value-dependent logic, I MUST use consistent
Hi!
Please send me an example (pseudo-code) for Serializable conflict.
And I wanna know, if possible, that if more transactions only read the
tables in Serializable mode, and one or others write to it, can I got some
conflicts in read operation?
c = client t = transaction
c1t1 begin serial
c1t1