On Montag 23 Februar 2009 Paul Stevens wrote: > 2.2. is dead from a development perspective. As far as I can tell > this issue is a performance hack. If you really need this: submit a > patch :-)
OK, good to know. So I need not spend time on investigating things there anymore. > x DELETE mymailbox > x CREATE mymailbox > > is a perfectly valid imap command sequence. That would imply renaming > such mailboxes into a 'attic'-like namespace, or else the create > command would fail. Like I said, doable, but not trivial. Just append the date in nanoseconds or whatever? Would be perfect for me, rename to mymailbox-32957329857923857 and set no_select. Like this all stuff is kept until admin decides. That would also be good for all companies that absolutely need e-mail backups. Example: companies working with stocks often must guarantee every single message is kept forever, even deleted. If dbmail doesn't auto-delete, but mark no_select, the admin can write a small script that greps all those into a backup and then deletes. > > You seem to be making a loop and then two updates per mailbox. Why > > not doing it all in one statement? The database is always faster > > with single commands, should be fine like: > > UPDATE dbmail_mailboxes SET no_select = 1 WHERE mailbox_idnr IN > > (SELECT mailbox_idnr WHERE name like 'mbx/to/delete%'); > > UPDATE dbmail_messages SET status=PURGE WHERE mailbox_idnr IN > > (SELECT mailbox_idnr WHERE name like 'mbx/to/delete%'); > > Yuk. IMAP-DELETE commands are always mailbox specific. Glob patterns > are evil in that context, afaict. Why? What's the difference if you code a recursive delete in C or in SQL? Can there be a problem with DELETE .. where x'=mail/box%' ? (Apart from dbmail having a bug, which can be in C too.). Sounds like you do not trust the database too much ;-) mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
