Hi.I had to do some optimizing of a user's mailboxes, so i wrote some useful SQL:
https://blog.lordvan.com/blog/dbmail-quickly-get-mailbox-counts-including-deleted-emails-postgresql/I assume that MySQL or oracle syntax would be a bit different (do they have FILTER ? no idea.. )
But maybe this is useful for someone else.also that VIEW is very handy to quickly get an idea of folder message counts :)
Regards
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://lists.nfg.nl/mailman/listinfo/dbmail
