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
