"Hans H" <jac.habers@hccnet.nl> wrote in message
news:4624e4a4$0$990$9a622dc7@news.kpnplanet.nl...
>
> "adzir" <muadzir@yahoo.com> schreef in bericht
> news:1176523222.383015.210680@o5g2000hsb.googlegro ups.com...
>> Hi,
>>
>> Just asking out of my curiosity. Which of these can hamper performance
>> of my online applications?
>>
>> Having multiple small databases open concurrently or huge size of one
>> single database? What happen for its long term run?
>>
>
> That is a tricky one. What is huge?
> If you have lots of queries, that will join those small tables, you will
> pay
> a perfomance penalty.
> Having one huge database might get you to the limits of the OS.
>

Funny you mentioned this, because in todays lessons we have learned about
this.
It's safer to have multiple small databases because of "update anomalies".
My tech-English is not that good, so I find it difficult to explain. Google
it.