I don't know about making 100 tables for 100 users, that doesn't sound like a good idea to me. Not that it won't work, it will work, but if you ever have to change the structure of your database due to a program change on the client end, you have to change 100 tables.
I wrote something that goes out and retreives mail from a POP3 server and stores it in a MySQL database. Basically, I have tables for each header (to,cc,bcc,subject,etc), a table for attachments and a table for the actual body of the message along with which user_id that message belongs to. Of course, the client program joins all these tables together to make the mail message when the user wishes to read/reply to it. Hope this helps. --------------------- Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -----Original Message----- From: Haryana [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 1:28 AM To: [EMAIL PROTECTED] Subject: MySQL as Mailbox storage Hi, I have a job to make a mail server that store mail data in mysql table. Currently we used a maildir based mail server, that store each mail data in one ordinary file. Therefore, I need some advise in choosing between storing the whole mail data in one big mysql table, or storing per user mail data in one table (means 100 users = 100 table), considering performance and reliability ? Any advise will be appreciated. TIA, Haryana eBdesk Ltd. - Indonesia --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php