A simple program for testing the single-core processing capability of a Database Server

A simple program to test the single-core processing capability of the database server. The author claims to have tested hundreds of different U types, the fastest being the IntelXeonX56803.33GHzsix running on linux-

A simple program to test the single-core processing capability of database servers, the author claims to have tested hundreds of different U, the fastest running Intel Xeon X5680 3.33 GHz six-on linux-

The storage process from Julian Dyke to test the single-core CPU performance can test the single-core CPU processing capability. By the way, I also tested

SET SERVEROUTPUT ON

SET TIMING ON
DECLARE
N NUMBER: = 0;
BEGIN
FOR f IN 1 .. 10000000
LOOP
N: = MOD (n, 999999) + SQRT (f );
End loop;
DBMS_OUTPUT.PUT_LINE ('res = '| TO_CHAR (n, '192. 99 '));
END;
/

The following is an output sample:
SQL>/
Res = 873729.72
PL/SQL procedure successfully completed.
Elapsed: 00:00:19. 87

The author claims to have tested hundreds of different U types, the fastest of which is the Intel Xeon X5680 3.33 GHz six-core running on linux, 8.92 seconds.

(Of course, this script is a simple test and is not comprehensive. The single-core speed is not all about a CPU. For reference only)

Test results: I tested several types of CPUs, and it turned out that one of my testing machines (Intel CPU) was the fastest, killing HP and IBM in seconds. Of course, the single-core processing capability is only one aspect, stability and concurrency are the secrets of small machines

HPUX anteng Platform
Elapsed: 00:00:34. 98
Uname-
HP-UX wbdb2 B .11.31 U ia64 1705335017 unlimited-user license

CPU info:
16 Intel (R) Itanium 2 9100 series processors (1.6 GHz, 18 MB)
533 MT/s bus, CPU version A1
32 logical processors (2 per socket)

Ibm power 7 Platform
Elapsed: 00:00:15. 91
Lsattr-E-l proc0
Frequency 3550000000 Processor Speed False
Smt_enabled true Processor SMT enabled False
Smt_threads 4 Processor SMT threads False
State enable Processor state False
Type PowerPC_POWER7 Processor type False


AMD CPU
Time: 00: 00: 22.43
[Root @ dtydb3 ~] # Uname-
Linux dtydb3 2.6.18-194. el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
Vendor_id: AuthenticAMD
Model name: AMD Opteron (tm) Processor 6128 HE
Stepping: 1
Cpu MHz: 800.000
Cache size: 512 KB

INTEL CPU

Elapsed: 00:00:11. 65
Uname-
Linux dtydb0 2.6.18-194. el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
Processor: 0
Vendor_id: GenuineIntel
Cpu family: 6
Model: 44
Model name: Intel (R) Xeon (R) CPU E5649 @ 2.53 GHz
Stepping: 2
Cpu MHz: 1596.000
Cache size: 12288 KB