Re: Good News for MS Windows users: Your favorite database is here..

nsouto_at_nsw.bigpond.net.au.nospam (Nuno Souto) writes:

<bunch of stuff deleted>

> When was the last time you tried to saturate 12 CPU's on a Sequent
> with a single DB2 parallel query?

Look at DB2's 300 GB TPC-H results from a year ago, http://www.tpc.org/tpch/results/h-ttperf.idc. DB2 published three results on numa-q (previously known as Sequent). Results are on 64, 48 and 32 cpus, and they scale well just look at the numbers! And I can promise that even for the 64 cpu runs, all the cpus were saturated, the scalability kind of proves that. Q.E.D.

BTW, they are still #1, 2 and 4 on the list after one year!

300 GB Results
Rank Company System QphH Price/QphH System Availability Database Operating System Date Submitted 1 NUMA-Q 2000 7334 616 US $ 08/15/00 IBM DB2 UDB 7.1 DYNIX/ptx 4.5.1 05/03/00 2 NUMA-Q 2000 5923 653 US $ 09/05/00 IBM DB2 UDB 7.1 DYNIX/ptx 4.5.1 09/05/00 3 AlphaServer GS320 Model 6/731 4951 983 US $ 08/31/00 Informix XPS 8.30 FC3 Compaq Tru64 UNIX V5.1 07/13/00 4 NUMA-Q 2000 4027 652 US $ 09/05/00 IBM DB2 UDB 7.1 DYNIX/ptx 4.5.1 09/05/00 5 9000 V2500 Enterprise Server 3714 1119 US $ 12/17/99 Informix Extended Parallel Server 8.30 FC2 HP HP-UX 11.00 10/21/99 6 AlphaServer ES40 Model 6/667 2832 1058 US $ 02/14/01 Informix XPS 8.31 FD1 Compaq Tru64 UNIX V5.1 12/19/00 7 9000 N4000 Enterprise Server 1592 973 US $ 05/02/00 Informix Extended Parallel Server 8.30 FC2 HP HP-UX 11.00 05/02/00 8 ProLiant 8000-8P 1506 280 US $ 11/17/00 Microsoft SQL Server 2000 Microsoft Windows 2000 11/17/00 9 NetServer LXr 8500 1402 207 US $ 08/18/00 Microsoft SQL Server 2000 Microsoft Windows 2000 08/18/00

Regards,

-- 
Haider