Paul J Stevens wrote:
Hans Kristian Rosbach wrote:
Just a few features I currently wish for:
-Shared Quota (whole domain for ex.)
A domain with 10 accounts can have 10MB quota,
but that does not mean that each account should
have 1MB each. Separate quota table?
(MUST HAVE)
That's quite simple actually:
add a dbmail_clients table, which contains
create table dbmail_clients (
client_idnr bigint(21) not null,
client_maxmail bigint(21) not null,
client_curmail bigint(21) not null
);
I don't think I like this design. I think that there is already a lot
of contention on the dbmail_users table having to update the mail_size
field (we have heard reports of significant performance boosts on busy
servers by disabling this feature), the contention will be that much
greater if every mail received for every user in a domain all have to
update the same record.
I think a better solution is to create the table you suggested without
the client_curmail field. That way you can still specify a maxmail size
for any given client, but don't have the update contention. When
delivering a message you can check the quota by doing something like
"select sum(curmail_size) from dbmail_users where client_idnr = x".
Thoughts?
