[OJB-developers] ODMG Performance vs Broker Performance

[Matthew B. <ma...@so...>]

I wrote an equivalent to the broker performance test for the ODMG API.
Enclosed are the results.

I will check in the new performance test soon.

Summary

Inserting is average 384% slower in ODMG
Updating is average 392% slower in ODMG
Querying (hot and cold cache) is average % slower in ODMG (invalid results,
I think maybe objects didn't get deleted?)
Fetching is average 1512% slower in ODMG
Deleting is average 522% slower in ODMG

Test machine
AMD XP 2100
Windows XP
768M DDR RAM
40G IBM GXP60 HD
SQL Server Developer Edition

I ran the test inside IDEA. It might be faster outside, but I ran both in
the same environment.

ODMG

[BOOT] INFO: OJB.properties:
file:/D:/eclipse/workspace/ojb-1-0/target/test/ojb/OJB.properties
.[BOOT] INFO: loading XML took 621 msecs
[performance] INFO: 
[performance] INFO: inserting 10000 Objects: 55480 msec
[performance] INFO: updating 10000 Objects: 49111 msec
[performance] INFO: querying 10000 Objects: 44774 msec
[performance] INFO: querying 10000 Objects: 43553 msec
[performance] INFO: fetching 10000 Objects: 56321 msec
[performance] INFO: deleting 10000 Objects: 43092 msec
[performance] INFO: 
[performance] INFO: inserting 10000 Objects: 43602 msec
[performance] INFO: updating 10000 Objects: 45616 msec
[performance] INFO: querying 10000 Objects: 83941 msec (SUSPECT)
[performance] INFO: querying 10000 Objects: 86244 msec (SUSPECT)
[performance] INFO: fetching 10000 Objects: 55940 msec
[performance] INFO: deleting 10000 Objects: 40048 msec

Time: 648.803

BROKER

[BOOT] INFO: OJB.properties:
file:/D:/eclipse/workspace/ojb-1-0/target/test/ojb/OJB.properties
.[BOOT] INFO: loading XML took 421 msecs
[performance] INFO: 
[performance] INFO: inserting 10000 Objects: 13470 msec
[performance] INFO: updating 10000 Objects: 12127 msec
[performance] INFO: querying 10000 Objects: 23063 msec
[performance] INFO: querying 10000 Objects: 15703 msec
[performance] INFO: fetching 10000 Objects: 3805 msec
[performance] INFO: deleting 10000 Objects: 8042 msec
[performance] INFO: 
[performance] INFO: inserting 10000 Objects: 12297 msec
[performance] INFO: updating 10000 Objects: 11988 msec
[performance] INFO: querying 10000 Objects: 22302 msec
[performance] INFO: querying 10000 Objects: 15782 msec
[performance] INFO: fetching 10000 Objects: 3616 msec
[performance] INFO: deleting 10000 Objects: 7881 msec

Time: 150.737

OK (1 tests)