This is a rough rendering of a page from the old Prevayler wiki. Please see the new wiki for current documentation.
Although MySQL is about 2.8 times faster for transaction processing, Prevayler retrieves 100 objects among one million 3251 TIMES FASTER
than MySQL via JDBC, even when MySQL has all data cached in RAM!
Many people have a hard time believing that. Take a look at the ScalabilityTestResults
. Examine and run the ScalabilityTest
Back to: ObjectPrevalenceSkepticalFAQ
Not really. Your Scalability Test Results show that SQL Server (glup!) is faster. Also on the retrieval part of the test, MySQL
used a SQL query, where as Prevayler
just tranversed a set of objects. Since Prevayler
doesn't include a query language, that's comparing apples to oranges.
Although that would be silly, WE CAN
even write a Prevayler
test implementation using SQL. Your problem is that YOU CANNOT
write a MySQL
test implementation without using SQL. @;) --KlausWuestefeld
The test was run by different people on different configurations. This is what gives it credibility. Therefore, it cannot be used as a comparison between MySQL
and ORACLE, though. If you have different results, you are free to post them here. --KlausWuestefeld