Re: multiple databases
| From: | Michael Hall | Date: | Wed, 28 Feb 2001 09:02:34 +0000 |
| Subject: | Re: multiple databases | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-41985@lists.php.net to get a copy of this message | ||
> Do you mean 10 different database servers, or 10 databases on the one
> server?
10 databases on the one server.
> As far as I know, separate databases on the one server give the same
> performance as separate tables in one database.
Music to my ears.
> With separate database servers you will run into new problems such as:
> -) can't combine data from servers, e.g. can't JOIN tables
OK ... I didn't realise I could join tables across seperate databases.
Anywhere where joins are necessary, I'm using the one database.
Thanks
Mick