Re: Databases in a server box

Sybrand Bakker wrote:
>
> There is NO reason why multiple applications can't reside in one
> single database. Security won't be compromised if you do so. Multiple
> applications of *one single customer* should go into *one database*
> especially when it is quite likely redundant data is going to be
> maintained in multiple databases. This will increase maintenance
> cost.

Come now Sybrand, there are plenty of good reasons to run different applications in different databases. Different apps can have vastly different user loads, uptime requirements, backup requirements, testing requirements, disk requirements, cpu/memory requirements, networking requirements, etc. Multiple databases for heterogenous apps can be perfectly reasonable. Same goes with multiple instances on the same host - there are plenty of good reasons to do this (and other good reasons why you shouldn't, but it totally depends on the particular needs of the company).

Regards,
Sean Received on Thu May 02 2002 - 13:16:45 CDT