Over 500 Tables ?

Thread View: borland.public.cppbuilder.database.multi-tier

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Sasan Wed, 05 Oct 2005 10:25

#105

Author: Sasan
Date: Wed, 05 Oct 2005 10:25

7 lines
1160 bytes

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 ?

Best Regards,
M.T

Re: Over 500 Tables ?

#106

Author: Giuliano
Date: Wed, 05 Oct 2005 10:57

35 lines
2286 bytes

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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads