🚀 go-pugleaf

On Wed, 5 Oct 2005 13:55:14 +0330, "Sasan" <sasan_vm@yahoo.com> wrote:

>Hello,
>I use SQL-Serevr for my database application,
>i have more than 500 tables and split it in 2 databases,
>i want know may be this design decrease application speed ?

If you are creating relations (making queries),  
using objects from both databases, you could to experiment   
degraded performances. Normally, this kind of queries   
are called "heterogeneous queries".

AFAIK, server's optimizers (even if databases are owned by 
the same server), don't play very much with relations coming 
from different databases (database = groups of tables, views, 
stored procedures, rules, etc etc).

Moreover, if you are using databases' access technologies 
like ADO, is possible that some parts of yours join, they 
could be made "locally". If so, the network traffic is 
unavoidably increased 'cause amount of transmitted data 
isn't reduced at server side. Only the server has "intimate"
semantics of structure (schema) you have created in the 
database. 

Again, AFAIK, it's not possible to have referential
integrity between different databases, so I suggest 
you, if it's possible, "to reduce" (denormalize) 
your database schema, and put  all your objects 
(tables, views, stored procedures, etc etc) in the 
same place.

Best regards.

Giuliano