"Aaron Stone" <[EMAIL PROTECTED]> writes: > This also underscores the need for transactions, otherwise it would be > possible for two messages to be inserted at almost the same time and lose > count of the size of one of those messages. A full recalculation as part of > the maintenance script might tide us over in the mean time...
As long as you're doing the addition in your SQL (update blah set quota = quota + size) statement, there should be no problem of lost additions. Without begin/commit, transactions are implicit in PostgreSQL, and such actions are atomic in MySQL. Not that I wouldn't like to see transactions done for their performance benefits. Mike -- You've got to promise not to stop when I say when -- Foo Fighters
