25 Jul
2007
25 Jul
'07
6:08 a.m.
On 25.7.2007, at 1.03, David Jonas wrote:
INSERT INTO quota (current, path, username) VALUES (0, 'quota/ storage', 'user@example.com') ON DUPLICATE KEY UPDATE current = current + 0;
So it's only added to or inserted, never changed then replaced.
OK, so absolutely nothing about the INSERT (including whether or
not it is performed) depends on anything about the result from the SELECT?I won't pretend to know for sure, but as far as I can tell, no.
Right.
I never poked around to find out why the SELECT is done.
v1.0 code does it at the beginning of each mailbox transaction. I've
already fixed in v1.1 code so that it's done only when quota checking
is actually needed.