Certainly 1 db with 16 tables. Since it will be read only and then write only, I would also use MyISAM instead of InnoDB, although I could be wrong, anyone else?
-----Original Message----- From: Stephen S Zappardo [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 12:13 PM To: [EMAIL PROTECTED] Subject: best practices Hello, I'm trying to determine the best way to setup a new mysql install. I have about 100 clients and each client has the same 16 tables. In a years time there will be about 3.6 million total rows spread out between the tables. The tables will be updated nightly from a legacy system. All other i/o will be reads only. In a raid5 configuration, which is a better design as far as access speed: a) 1 db with 16 tables b) 100 dbs each with 16 tables Thanks, steve --------------------------------------------------------------------- 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
