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...
Aaron Ilja Booij <[EMAIL PROTECTED]> said: > I've made some minor adjustments to the way quota are handled. Or > rather, to the way that a user's quotum is updated. Instead of using > db_calculate_quotum_used() after every insert, I've now used a new > function db_add_quotum_used() which adds the message size to the new > quotum. > > This is all fine, and it works, except for the fact that the > curmail_size is not lowered again on deletion of a message. I'll fix > that tomorrow. :) > > This stuff should gives us some more speed (less complex queries), > especially on message insertion. > > Ilja > > _______________________________________________ > Dbmail-dev mailing list > [email protected] > http://twister.fastxs.net/mailman/listinfo/dbmail-dev > --
