[Tutor] Multiple DBs per application?
alan.gauld at btinternet.com
Tue May 15 00:44:52 CEST 2012
On 14/05/12 20:33, leam hall wrote:
> Just a general question. If you have an application with different
> data types where it might be better to use one database over another,
> are there issues with having multiple databases used by the
No, you can usuially have multiple databases open at once.
You can have multiple instances of the same database or
different database types.
However the data types are rarely ta reason to use different databases.
More typically would be different performance requirements or security
issues. For example it's common to hold some data in an LDAP structure
for speed of access (at the expense of flexibility) and the rest of the
data in an RDBMS such as MySql. But using say MySQL and Oracle together
would normally only be done because they were pre-existing datastores
from another project.
Author of the Learn to Program web site
More information about the Tutor