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 (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php