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.


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.

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to