Re: [PHP-DB] One or Many Databases?

2004-07-31 Thread Ross Honniball
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.ta

Re: [PHP-DB] One or Many Databases?

2004-07-31 Thread John Holmes
Paul Burney wrote: Hello everyone, I'm developing a "community system", that has things like members, roles, events, etc. Currently everything is in multiple tables of a single MySQL database. It looks something like this... --- Communities - community_id P