ScalabilityTestByDanielSantos

This is a rough rendering of a page from the old Prevayler wiki. Please see the new wiki for current documentation.

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)   
Where is the code used in these tests?

Download the newest Prevayler version and read the Readme.txt file. @:p