Re: Top Databases Used

Posted in 2000

Obnoxio The Clown — Fri, 14 Apr 2000 09:42:50 BST — source: Informix-list mailing list archive (1991-1998)

From: Norris <jcheong@cooper.com.hk> > >Here is the summary for TPCC Top 20 > >Database Cluster Non-cluster >-------- ------- ----------- >Oracle 6 6 >Sybase 0 4 >MS-SQL 2 1 >DB2 for AS/400 0 1 >=========================================== >Total 8 12 Here is the summary for TPC-H Top 5: Database 100GB 300GB 1000GB MS-SQL 3 Informix 1 1 And TPC-R top 2: Database 1000GB Teradata 2 ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

↪ replying to Carlos Bolden

David Williams — Sun, 16 Apr 2000 17:26:25 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <sfhai3ecivv51@news.supernews.com>, Carlos Bolden <1cbolden@bellsouth.net> writes >Well it depends on all what you will be doing with your database. OLTP >"based stuff" Informix, no doubt, fastest in the market at oltp with little >or no headaches. > >Warehousing data of 1 terabyte or more, Teradata, period. Easy to manage, >DBA's dream. "Stuff's not running fast, Add more Nodes and more disk". The >only drawback is that it is very expensive. Going this route, make sure >your ROI is high and this is what you want. What about Informix XPS? Also can add more nodes/disk. I have heard it scale up to 176 nodes!! -- David Williams

↪ replying to Obnoxio The Clown

Carlos Bolden — Sun, 16 Apr 2000 12:39:46 -0500 — source: Informix-list mailing list archive (1991-1998)

Well it depends on all what you will be doing with your database. OLTP "based stuff" Informix, no doubt, fastest in the market at oltp with little or no headaches. Warehousing data of 1 terabyte or more, Teradata, period. Easy to manage, DBA's dream. "Stuff's not running fast, Add more Nodes and more disk". The only drawback is that it is very expensive. Going this route, make sure your ROI is high and this is what you want. "Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message news:8d6nse$js6$1@news.xmission.com... > > From: Norris <jcheong@cooper.com.hk> > > > >Here is the summary for TPCC Top 20 > > > >Database Cluster Non-cluster > >-------- ------- ----------- > >Oracle 6 6 > >Sybase 0 4 > >MS-SQL 2 1 > >DB2 for AS/400 0 1 > >=========================================== > >Total 8 12 > > Here is the summary for TPC-H Top 5: > > Database 100GB 300GB 1000GB > MS-SQL 3 > Informix 1 1 > > And TPC-R top 2: > > Database 1000GB > Teradata 2 > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com >