Re: Choosing a right database

From: Erich Huemoeller <huemoea_at_(remove-this.)swib.state.wi.us>
Date: Mon, 23 Aug 1999 08:57:55 -0500
Message-ID: <7prkiq$8b71@Musky.state.wi.us>

A couple issues I don't see being addressed here are: what hardware platform is this thing going to run on, and what size is the database you'll be putting out there now and later?

There are a lot of databases that cross over hardware types, but many don't work as well on one as they do on the other. There are people who swear by DB2 (MVS or UNIX), Terdata, Oracle and Informix. You won't likely get an unbiased opinion. You're talking some fairly large numbers here and I assume that you'll probably be purchasing some hardware to support this system. You might as well select a pair that function well together.

Erich Huemoeller

Alla Gribov <alla.gribov_at_metatel.com> wrote in message news:37C004E0.24C40572_at_metatel.com...
> Hello all;
>
> First of all I am apologizing to all of you if you see this questions
> posted twice - I am having troubles with sending it.
>
> I need an advice from gurus of database design and development
>
> I am building a database that will have around 1 million users. At any
> given moment about 5,000 of them are connected to the database.
> The chosen database should be able to perform around 500 reads/writes
> per second.
>
> Is there a database that can support such a task and if yes, which one
> is the best in your opinion?
>
> My first thought was Oracle, but after doing some research on Web, it
> seems like that a lot of people prefer Informix over Oracle.
>
> Which would you choose (or may be there are some other databases that I
> am not aware of that would suit better for this project) - no Sybase or
> MS Sql-Server,
> sorry to people who like them???
>
> Your help is greatly appreciated.
>
> Thanks in advance
>
>
>

/***************************************************************************
*/


>                                  Alla Gribov


>                        alla.gribov_at_metatel.com

> The greatest programming project of all took six days. On the seventh
> day the programmer rested. We've been trying to debug the thing ever
> since. Moral: design before you implement.
>

/***************************************************************************

*/ Received on Mon Aug 23 1999 - 08:57:55 CDT