Michael Mayer wrote: > Paul J Stevens wrote: >> formail -ds dbmail-smtp -u testuser$i -m mailbox$j > > Do I have to add those 100 testusers and mailboxes first or will that > happen automatically for some reason?
users are not created automatically, mailboxes are if you use the pipe interface (dbmail-smtp aka dbmail-deliver). > > As far as I understood the script, it will add each mail to 100 > mailboxes shared by 100 users, so it will create 10.000 mails for each > input email, right? Or is dbmail smart enough to just create 100 > database rows (one for each mailbox or user), because the mail body is > 100 times the same in each mailbox? I saw the md5 hashes and that might > be, what they are good for. The idea is to create 100 users with each 100 mailboxes, and fill each of these 10000 mailboxes with the number of messages you have in your test mbox. If you have 1000 messages that will result in: 10e6 rows in dbmail_messages (one for each message) and beyond that are the number of rows in the other tables, depending on the storage data model which differs greatly between 2.2 and 2.3. The messages table contains 'virtual' messages are represented as a 'message' in a 'mailbox'. They do contain a reference to a 'real' message as stored in 'messageblks' until 2.2. The md5 unique_id in the messages table is a field only used by POP3 (and targetted for removal for being redundant). In 2.3+ the actual messages are fully recursively dissected into their constituant mimeparts. Mimeparts are stored as a single-instance rows in dbmail_mimeparts. The hash field in that table is used to quickly located possible duplicates to prevent them from being stored more than once. The actual comparison being byte by byte. The tables that are prime targets for improvement - next to dbmail_messages - are dbmail_mailboxes since it's used in just about all the joins that hit dbmail_messages, and dbmail_headervalue because it grows too big since each header for each real messages. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
