Let's just assume I have 2 TB diskspace free for a couple of very heavy mail-users on a production server that would never even reach quota issues before the server goes offline in, say, 10 years. Whenever I admin dovecot, it polls for quota. I have already disabled the Quota plugin, but the sql query still has; user_query = SELECT email as user, maildir as home, CONCAT( maildir_format, ':', maildir, '/', IF(maildir_format='maildir','Maildir',maildir_format)) as mail, uid, gid, CONCAT('*:storage=', quota, 'B') AS quota_rule, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE (login = '%u' OR email = '%u') AND `disable%Ls` = 'n' AND server_id = '1' so it returns sql responses, what I would like to know is how to safely change this query so I don't have this excess mysql querying. And how I can have this override the /etc/dovecot/dovecot-sql.conf entry so it remains active, even if I upgrade ispconfig or other config changes take place? Can I just change it to: user_query = SELECT email as user, maildir as home, CONCAT( maildir_format, ':', maildir, '/', IF(maildir_format='maildir','Maildir',maildir_format)) as mail, uid, gid, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE (login = '%u' OR email = '%u') AND `disable%Ls` = 'n' AND server_id = '1' ? Thanks in advance.
