Re: big, fast, etc, was is Vax addressing sane today

On Fri, 13 Sep 2024 21:50:15 -0000 (UTC)
John Levine <johnl@taugh.com> wrote:

It appears that Michael S  <already5chosen@yahoo.com> said:

There's also a rule of thumb about databases that says one system
of performance 100 is much better than 100 systems of performance 1
because those 100 systems will spend all their time contending for
database locks. 

>
How many transactions per minute does world's biggest company need at
peak hours?  

 
Ten years ago Visa could process 56,000 messages/second. It must be a
lot more now. I think a transaction is two or four messages depending
on the transaction type.
 

Is not this number small relatively to capabilities of
even 15 y.o. dual-Xeon server with few dozens of spinning rust
disks? 

 
Uh, no, it is not.
 
 

I probably was not clear enough. I have no doubts that there exist jobs
for which the machine that I mentioned above is insufficient.
I just don't believe that flight reservation is one of such jobs.

BTW, tcp.org site is down, so I can not find OLTP bechmarks for the
sort of machines that I mentioned in my previus post. Quite possibly
they (scores) do not exsit, because in 2009 people already stopped
benchmarking OLT with rotating media.
For reference, the best TPC-C score for 2-way Xeon in 2010 is 803,068
tpmC, but that score uses SSDs. IIRC, that's ~80% of the world's
absolutely fastest non-clustered score of 2003.

I am posting a link with a hope that tcp.org will be up tomorrow.
http://www.tpc.org/results/individual_results/HP/hp_DL380_TPCC_051110_ES.pdf