On Thu, 28 Oct 2004 09:43:25 +1300, Mark Mackay - Orcon <[EMAIL PROTECTED]> wrote: > We've disabled the quota checks in a 1.x version and it has produced a major > speed gain in the database. Previously our database was spiking to high > loads doing the SUM() calcs, so I wouldn't underestimate the cost of this > when you get to large message stores. > > If possible - it would be great to have a config item which could be enabled > to disable quota checks on delivery... Would save patching each release.
On DBMail 1.x, disabling quota checks does make a big difference. On DBMail 2.0, the user's current mail size is kept in users table, which prevents having to calculate the quotum every time. Ilja