List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 16 2000 5:48pm
Subject:Re: One huge, or many small databases
View as plain text  
At 9:49 AM -0700 09-16-2000, Jeremy D. Zawodny wrote:
>On Sat, Sep 16, 2000 at 03:46:40PM +0300, Tonu Samuel wrote:
>>  Arik Funke wrote:
>> 
>>  > Hello together,
>>  > can anyone tell me, if there is a difference (in performace, etc) between
>>  > making one huge database with 50 tables and creating 10 small ones with 5
>>  > tables?
>>
>>  No big difference from database internal point of view. But you
>>  itself will be in trouble if you need to combine queries between
>>  different databases.
>
>Really?
>
>I've never had a problem doing it. Is this documented somewhere?

Could be a problem if the databases were on different servers.
But that doesn't seem to be the situation here.


>
>Jeremy
>--
>Jeremy D. Zawodny, <jzawodn@stripped>
>Technical Yahoo - Yahoo Finance
>Desk: (408) 328-7878    Fax: (408) 530-5454
>Cell: (408) 439-9951


-- 
Paul DuBois, paul@stripped
Thread
One huge, or many small databasesArik Funke16 Sep
  • Re: One huge, or many small databasesTonu Samuel16 Sep
    • Re: One huge, or many small databasesJeremy D. Zawodny16 Sep
      • Re: One huge, or many small databasesPaul DuBois16 Sep
  • Re: One huge, or many small databasesTonu Samuel16 Sep
Re: One huge, or many small databasesArik Funke16 Sep