Re: One or Many Databases?
| From: | Ross Honniball | Date: | Sat, 31 Jul 2004 22:12:16 +0000 |
| Subject: | Re: One or Many Databases? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-35508@lists.php.net to get a copy of this message | ||
At 07:41 AM 1/08/2004, you wrote:
More server load (??? - Using PEAR, I think each separate database would be a separate connection)No you won't. When you code up your DB Query, you can specify the database that a table comes from by simply using a period as a seperator. eg. select * from db1.table1 as t1, db2.table2 as t2 where t1.fld_x = t2.fld_x The default database that pear FORCES you to connect to is only the default database. PS Overall, if you are only dealing with 25 tables, I don't think it matters too much to break it into multiple db's or not. If you are possibly expanding significantly than it may be another story. If it aint broke? . . Ross Honniball. JCU Bookshop Cairns, Qld, Australia. .