Since certain people are accusing us of FUD in the mailing list of their
project, I might as well publish some info. I've been aware of these kind of
results for a while, but have never ever publicised them.
One of the OJB performance tests has been reimplemented for Hibernate (by
Matt Baird of OJB, and tweaked by me) and heres some numbers. Everyone can
draw their own conclusions. I don't personally put much stock in these kind
of toy test cases. Results like this don't really tell you how a system will
scale with multiple threads / servers. So take all with a grain of salt.
(You should take the third test run as most representative.)
OJB (DB2)
=========
inserting 1000 Objects: 3203 msec
updating 1000 Objects: 1906 msec
querying 1000 Objects: 2235 msec
querying 1000 Objects: 46 msec
deleting 1000 Objects: 1391 msec
inserting 1000 Objects: 1531 msec
updating 1000 Objects: 1562 msec
querying 1000 Objects: 2110 msec
querying 1000 Objects: 828 msec
deleting 1000 Objects: 1375 msec
inserting 1000 Objects: 1500 msec
updating 1000 Objects: 1516 msec
querying 1000 Objects: 1890 msec
querying 1000 Objects: 797 msec
deleting 1000 Objects: 1265 msec
Hibernate (DB2)
===============
inserting 1000 Objects: 1719 msec
updating 1000 Objects: 875 msec
querying 1000 Objects: 1640 msec
querying 1000 Objects: 78 msec
deleting 1000 Objects: 641 msec
inserting 1000 Objects: 891 msec
updating 1000 Objects: 656 msec
querying 1000 Objects: 1422 msec
querying 1000 Objects: 187 msec
deleting 1000 Objects: 656 msec
inserting 1000 Objects: 547 msec
updating 1000 Objects: 625 msec
querying 1000 Objects: 1344 msec
querying 1000 Objects: 16 msec
deleting 1000 Objects: 532 msec
OJB (MySQL)
===========
inserting 1000 Objects: 2218 msec
updating 1000 Objects: 1750 msec
querying 1000 Objects: 2219 msec
querying 1000 Objects: 1438 msec
deleting 1000 Objects: 1125 msec
inserting 1000 Objects: 1312 msec
updating 1000 Objects: 1453 msec
querying 1000 Objects: 1687 msec
querying 1000 Objects: 1500 msec
deleting 1000 Objects: 1125 msec
inserting 1000 Objects: 1297 msec
updating 1000 Objects: 1500 msec
querying 1000 Objects: 1953 msec
querying 1000 Objects: 781 msec
deleting 1000 Objects: 1078 msec
Hibernate (MySQL)
=================
inserting 1000 Objects: 1422 msec
updating 1000 Objects: 1407 msec
querying 1000 Objects: 2125 msec
querying 1000 Objects: 93 msec
deleting 1000 Objects: 891 msec
inserting 1000 Objects: 875 msec
updating 1000 Objects: 1109 msec
querying 1000 Objects: 1766 msec
querying 1000 Objects: 16 msec
deleting 1000 Objects: 765 msec
inserting 1000 Objects: 985 msec
updating 1000 Objects: 921 msec
querying 1000 Objects: 1735 msec
querying 1000 Objects: 15 msec
deleting 1000 Objects: 704 msec
OJB (HSQL)
==========
inserting 1000 Objects: 6360 msec
updating 1000 Objects: 1172 msec
querying 1000 Objects: 609 msec
querying 1000 Objects: 31 msec
deleting 1000 Objects: 375 msec
inserting 1000 Objects: 547 msec
updating 1000 Objects: 953 msec
querying 1000 Objects: 438 msec
querying 1000 Objects: 15 msec
deleting 1000 Objects: 360 msec
inserting 1000 Objects: 578 msec
updating 1000 Objects: 875 msec
querying 1000 Objects: 234 msec
querying 1000 Objects: 16 msec
deleting 1000 Objects: 250 msec
Hibernate (HSQL)
================
inserting 1000 Objects: 890 msec
updating 1000 Objects: 1063 msec
querying 1000 Objects: 890 msec
querying 1000 Objects: 78 msec
deleting 1000 Objects: 344 msec
inserting 1000 Objects: 594 msec
updating 1000 Objects: 781 msec
querying 1000 Objects: 656 msec
querying 1000 Objects: 172 msec
deleting 1000 Objects: 282 msec
inserting 1000 Objects: 437 msec
updating 1000 Objects: 797 msec
querying 1000 Objects: 453 msec
querying 1000 Objects: 16 msec
deleting 1000 Objects: 235 msec
|
