On Wed, 3 Aug 2011 16:46:23 +0200 giampa...@tomassoni.biz wrote: > I think your suggestion is an overkill.
Not in my experience. > Iff I'm right about the problem being on transaction competition, it > can be solved by a much easier solution. The way bayes uses and > updates tokens data would allow reading in a transaction and writing > in a new one: you always increase tokens occurrences by a value > which doesn't depend on the value they had at read time. Concurrent updates of the same row alway cause contention. Believe me, we know this through bitter experience and not theory. That's why we went to all the trouble of ensuring there'd only ever be one writer. Regards, David.