Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Choosing a right database

Re: Choosing a right database

From: BC <bobREMOVETHISclary_at_twcny.rr.com>
Date: Mon, 23 Aug 1999 10:51:56 -0400
Message-ID: <5kdw3.1626$w6.39133@typhoon.nyroc.rr.com>


I think the writer said Oracle Rdb, which is the Rdb VMS from Digital Equipment Corp. Your comments are about a different database. The statements are essentially correct about Oracle Rdb.

Art S. Kagel <kagel_at_bloomberg.net> wrote in message news:37C15E0C.CE0DA8B4_at_bloomberg.net...
> I'm sorry if this starts an argument, it is not my intention, nor do I
> want to get into a p**sing match over features. However, I could not let
> such a patently false statement to go by.
>
> Magnus Weiman wrote:
> >
> > For this kind of workload, the best option would be Oracle Rdb. No other
> > RDBMS can offer the same performance and the same availability since
almost
> > every kind of database maintenance can be performed online.
>
> Ever try to move an Oracle table from one tablespace to another? Defrag
> an Oracle table? Alter a table to drop one or more columns? Does Oracle
> perform in-place Alter Table? I'm not saying Oracle is not maintainable,
> but the statement that 'almost every kind of database maintenance' can be
> performed online is not true. Informix has always been FAR more easily
> maintained in this way allowing one to do EVERY kind of database
> maintenance quickly and easily (OK the equivalent of TRUNCATE TABLE is
> DROP ....; CREATE...; but that's the only maintenance item I can think of
> that Oracle does better than Informix). On performance I'll post
> separately.
>
> Art S. Kagel
>
> > --
> > Name: Magnus Weiman Company: Datalogikonsult AB
> > http://www.datalogi.com mailto:magnus.weiman@datalogi.com
> > S-mail: Box 52, S-590 79 VRETA KLOSTER, Sweden
> > Phone: +46 13 68040 Fax: +46 13 68041 GSM: +46 70 7440806
> >
> > 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 - 09:51:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US