Re: [Zope-dev] RE: your mail

2001-04-10 Thread Federico Di Gregorio
Scavenging the mail folder uncovered Randall F. Kern's letter: > Read committed is faster, but I have not done any tests to know how much > faster. Read committed mode doesn't support concurrent updates either, > but fails silently. In other words, given to concurrent queries: > > update foo se

[Zope-dev] RE: your mail

2001-04-09 Thread Randall F. Kern
Read committed is faster, but I have not done any tests to know how much faster. Read committed mode doesn't support concurrent updates either, but fails silently. In other words, given to concurrent queries: update foo set a = a + 1 update foo set a = a + 2 Assuming these overlap, and a start

[Zope-dev] Re: your mail

2001-04-09 Thread Federico Di Gregorio
Scavenging the mail folder uncovered Randall F. Kern's letter: [snip] > Concurrent updates are not supported in the serializable transaction > mode; if one transaction tries to update (or delete) a row that has > already been updated by a concurrent uncommitted transaction, the second > transacti