Re: Choosing a right database

Is your application transactional (operational) or analytical (data warehouse)? There are systems that work in one realm but not the other. Of course, there are some that work in both and vendors who have different offerings in both.

Since you asked about two vendors in particular, I'll say that if you want a mainstream RDBMS vendor, Informix has better-performing, much-easier-to-administer offerings in both domains.

                                        Seth

Alla Gribov wrote:
>
> 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.
> /****************************************************************************/

--
Seth Grimes Alta Plana database & Web / design & development grimes@altaplana.com http://altaplana.com 301-873-8225 Received on Sun Aug 22 1999 - 21:21:01 CDT