From: Agustín Fernández <[EMAIL PROTECTED]> > Is there any reason to avoid having a large number of tables (which have > the same structure)?
You might run into a limit on the number of open file handles, but you'd have to check the MySQL docs for how he handles it, and possibly your OS docs to see what the limit is. > Would doing just-one-big-table (with a forum-id) be advisable? Very possibly. 100,000 records isn't huge, but it could be big enough to put a load on your machine. Unless you find a definative answer in the docs, I'd try testing both. --- Rodney Broom Programmer, R.Broom Consulting --------------------------------------------------------------------- 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
