New Instance vs. New Schema [message #49652] |
Fri, 01 February 2002 06:30 |
dpwdba
Messages: 1 Registered: February 2002
|
Junior Member |
|
|
What criteria is used to determine whether an application requires a new Instance be created versus
just creating schemas in an existing Instance?
|
|
|
Re: New Instance vs. New Schema [message #49667 is a reply to message #49652] |
Sun, 03 February 2002 08:48 |
Mike
Messages: 417 Registered: September 1998
|
Senior Member |
|
|
For the same application I recommand you, for performance and administration reasons to use only one instance and as many schemas as you want.
If the new instance wouldn't have any data related to the data of the existing instance and the performance of your existing database is low it maybe better to create a new database on a different server.
HTH
Mike
|
|
|