Results:
{#
|
Prevayler |
SQLServer |
MySQL
Queries per second | 215543,43 | 95.46 | 75,87
Manipulations per second | 55,42 | 144.50 | 298.31
#}
Number of Objects: One million.
Test Environment:
CPU: Pentium 900 MHz
Operating System: Windows 2000
DBMS: MS SQL Server 7.0 and
MySQL
DanielSantos.
----
See:
ScalabilityTestResults.
----
TEST LOGS
Prevayler
========= Running Query Test (5 rounds). Subject:
Prevayler...
Creating 1000000 objects...
100000...
200000...
300000...
400000...
500000...
600000...
700000...
800000...
900000...
Each round will take approx. 60 seconds to run...
Memory used: 500957184
Seconds ellapsed: 60.006
========= Round Result: 214922,57 operations/second (1 threads)
Memory used: 500957184
Seconds ellapsed: 60.016
========= Round Result: 215467,68 operations/second (2 threads)
Memory used: 500957184
Seconds ellapsed: 60.017
========= Round Result: 215543,43 operations/second (3 threads)
Memory used: 500957184
Seconds ellapsed: 60.006
========= Round Result: 215102,81 operations/second (4 threads)
Memory used: 500957184
Seconds ellapsed: 60.036
========= Round Result: 214756,35 operations/second (5 threads)
========= BEST ROUND: 215543,43 operations/second (3 threads)
========= Running Manipulation Test (5 rounds). Subject:
Prevayler...
Creating 1000000 objects...
100000...
200000...
300000...
400000...
500000...
600000...
700000...
800000...
900000...
Each round will take approx. 60 seconds to run...
Memory used: 500957184
Seconds ellapsed: 60.006
========= Round Result: 43,16 operations/second (1 threads)
Memory used: 500957184
Seconds ellapsed: 60.016
========= Round Result: 47,97 operations/second (2 threads)
Memory used: 500957184
Seconds ellapsed: 60.027
========= Round Result: 49,11 operations/second (3 threads)
Memory used: 500957184
Seconds ellapsed: 60.026
========= Round Result: 55,06 operations/second (4 threads)
Memory used: 500957184
Seconds ellapsed: 60.046
========= Round Result: 55,42 operations/second (5 threads)
========= BEST ROUND: 55,42 operations/second (5 threads)
----
SQL Server
----
MySQL
========= Running Query Test (5 rounds). Subject: JDBC...
Creating 1000000 objects...
100000...
200000...
300000...
400000...
500000...
600000...
700000...
800000...
900000...
Each round will take approx. 60 seconds to run...
Memory used: 2031616
Seconds ellapsed: 60.017
========= Round Result: 75,01 operations/second (1 threads)
Memory used: 2031616
Seconds ellapsed: 60.066
========= Round Result: 75,87 operations/second (2 threads)
Memory used: 2211840
Seconds ellapsed: 60.066
========= Round Result: 75,42 operations/second (3 threads)
Memory used: 2392064
Seconds ellapsed: 60.057
========= Round Result: 65,65 operations/second (4 threads)
Memory used: 2703360
Seconds ellapsed: 60.066
========= Round Result: 61,48 operations/second (5 threads)
========= BEST ROUND: 75,87 operations/second (2 threads)
========= Running Manipulation Test (5 rounds). Subject: JDBC...
Creating 1000000 objects...
100000...
200000...
300000...
400000...
500000...
600000...
700000...
800000...
900000...
Each round will take approx. 60 seconds to run...
Memory used: 2031616
Seconds ellapsed: 60.067
========= Round Result: 277,99 operations/second (1 threads)
Memory used: 2031616
Seconds ellapsed: 60.056
========= Round Result: 290,66 operations/second (2 threads)
Memory used: 2031616
Seconds ellapsed: 60.257
========= Round Result: 298,31 operations/second (3 threads)
Memory used: 2031616
Seconds ellapsed: 60.036
========= Round Result: 278,53 operations/second (4 threads)
Memory used: 2031616
Seconds ellapsed: 60.026
========= Round Result: 273,38 operations/second (5 threads)
========= BEST ROUND: 298,31 operations/second (3 threads)