Re: Sybase 11 TPCC on DEC (your comments please)

gtravis_at_richmond.infi.net (Glenn Travis) posted with deletions:

| Sybase Leapfrogs Competition; Achieves 'Best On Platform' With SQL Server11
 

| Source: PR Newswire
|
| EMERYVILLE, Calif., Dec. 22 /PRNewswire/ via NewsPage -- Sybase, Inc.
| (Nasdaq: SYBS), The Enterprise Client/Server Company(TM), today announced
| that Sybase(R) SQL Server(TM) 11 achieved the industry's best TPC-C
| benchmark results ever recorded on the 300 megahertz Digital AlphaServer
| 8400. The Sybase/Digital benchmark achieved 11,014 transactions per minute
| (tpmC) at a price/performance of $222 per tpmC with Sybase SQL Server 11 --
| 17 percent faster and 32 percent less expensive than Oracle's best
| performance result utilizing the same Digital Alpha chip.

The result seems specious as the TPC-C benchmark is not described.

By contrast, my "primitive" load tests on hardly an optimized object database in compiled BASIC, not in the target development language of Eiffel, produced this result on the following test on a 586-133, 32 MB, on one IDE hard disk, no buffer, no cache (hardly a $40,000 + Alpha box).

One transaction consists of 9-reads from 3-memory-tables, 4-reads from 4-disk-tables, and 10-writes to 6-disk-tables: 3,360 tpm (I don't know what "tpmC" is).

If a 300 MHz Alpha is linearly equivalent to a 133 MHz Pentium (which it may not be), then 300/133 or about 2.25 * 3360 tpm = 7580 tpm which is about 45% less than the Sybase mark. (It should be an order of magnitude less (10-times less or 1000% less), because my test is in a high-order language BASIC, not an intermediate-order language C.)

The Sybase results do not impress this writer.

~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ Colin James III, Principal Scientist cjames_at_cec-services.com CEC Services, 2080 Kipling St, Lakewood, CO 80215-1502 USA Voice: 303.231.9437; Facsimile: .231.9438; Data: .231.9434 ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ Received on Wed Jan 03 1996 - 00:00:00 CET