Hi, When it comes to very large databases, Oracle is a good choice. I have run databases of about 5GB on NT without much problem! And still larger ones on Solaris. It is very rugged. Only thing is that as the database grows you will have to do lot of tuning to keep the performance to acceptable limits. Postgresql should be a good choice for a secondary database. ie, if u can use it for day to day data collection and put the collected data periodically to Oracle. Postgres also supports integrity constraints and quick scripting now.
Slashdot Mirror
Hi,
When it comes to very large databases, Oracle is a good choice. I have run databases of about 5GB on
NT without much problem! And still larger ones on
Solaris. It is very rugged. Only thing is that as
the database grows you will have to do lot of tuning to keep the performance to acceptable limits.
Postgresql should be a good choice for a secondary database. ie, if u can use it for day
to day data collection and put the collected data
periodically to Oracle. Postgres also supports integrity constraints and quick scripting now.