Re: Choosing a right database
Well this begs the question. If you ask Oracle Corp. which product to use between Rdb and Oracle 7/8, which one do you think they would recommend? Even though, as you say, Rdb is better, anyone want to take odds that they would push it instead of Oracle 7/8? :-) Paul Storm > From owner-informix-list@iiug.org Mon Aug 23 12:15:03 1999 > From: "BC" <bobREMOVETHISclary@twcny.rr.com> > To: informix-list@iiug.org > Subject: Re: Choosing a right database > Date: Mon, 23 Aug 1999 10:58:02 -0400 > X-List-Gateway: comp.databases.informix > > You said it! I've worked with Rdb for years (12 years with DEC). I currently > work in a mixed Rdb and Oracle shop. There's no comparison. Orace 7 or 8 are > not 24*7 databases, Rdb is. In any environment requiring the highest > reliability and availability Rdb wins hands down. Too bad Oracle got their > hands on it. > > Magnus Weiman <magnus.weiman@datalogi.com> wrote in message > news:Sjdw3.8518$7d.16248@nntpserver.swip.net... > > Totally wrong!!! > > > > I'm talking about Oracle Rdb (not Oracle 7, not Oracle 8). This database > is > > very easy to maintain and give you state of the art performance. If you > need > > true 24*7 availability, easy maintenance and very high performance, take a > > look at Oracle Rdb!! > > > > And once again, I'm talking about Oracle Rdb, NOT Oracle8, NOT Oracle 7!!! > > > > > > Regards, > > > > Magnus Weiman > > > > -- > > 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 > > Art S. Kagel <kagel@bloomberg.net> wrote in message > > news:37C15E0C.CE0DA8B4@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@metatel.com> wrote in message > > > > news:37C004E0.24C40572@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@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. > > > > > > > > > > > > /*************************************************************************** > > > > */ > > > > > >