Re: Having lots of tables

2002-04-23 Thread Toomas Vendelin
Hello Agustín, Monday, April 22, 2002, 11:50:44 PM, you wrote: AF I have a question on a project i am currently on. I am adapting Phorum AF (www.phorum.org) to my own portal and have a doubt about MySQL. Phorum AF creates a table for each discussion forum. However, in the portal i work AF for,

Having lots of tables

2002-04-22 Thread Agustín Fernández
Hi, I have a question on a project i am currently on. I am adapting Phorum (www.phorum.org) to my own portal and have a doubt about MySQL. Phorum creates a table for each discussion forum. However, in the portal i work for, i currently have thousands of items that would potentially need a table

Re: Having lots of tables

2002-04-22 Thread Rodney Broom
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