AW: [OJB-developers] ODMG Performance vs Broker Performance

[Mahler T. <tho...@it...>]

Hi Matthew,

> -----Urspr=FCngliche Nachricht-----
> Von: Matthew Baird [mailto:ma...@so...]
> Gesendet: Dienstag, 21. Mai 2002 08:20
> An: 'obj...@li...'
> Betreff: [OJB-developers] ODMG Performance vs Broker Performance
>=20
>=20
> I wrote an equivalent to the broker performance test for the ODMG =
API.
> Enclosed are the results.
>=20
> I will check in the new performance test soon.
>=20
> Summary
>=20
> Inserting is average 384% slower in ODMG
> Updating is average 392% slower in ODMG
> Querying (hot and cold cache) is average % slower in ODMG=20
> (invalid results,
> I think maybe objects didn't get deleted?)
> Fetching is average 1512% slower in ODMG
> Deleting is average 522% slower in ODMG
>=20

The performance of the ODMG implementation seems rather bad compared =
with
JDBC.=20
But I'm not "shocked" by these results. I think they are only natural =
as the
ODMG layer is quite different from a simple data-access layer.

But I still think that your tests may be helpful to find performance
bottlenecks and to avoid performance regressions through changes to the
codebase.

cheers,

Thomas



> Test machine
> AMD XP 2100
> Windows XP
> 768M DDR RAM
> 40G IBM GXP60 HD
> SQL Server Developer Edition
>=20
> I ran the test inside IDEA. It might be faster outside, but I=20
> ran both in
> the same environment.
>=20
> ODMG
>=20
> [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:=20
> [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:=20
> [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
>=20
> Time: 648.803
>=20
> BROKER
>=20
> [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:=20
> [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:=20
> [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
>=20
> Time: 150.737
>=20
> OK (1 tests)
>=20
> _______________________________________________________________
>=20
> Don't miss the 2002 Sprint PCS Application Developer's Conference
> August 25-28 in Las Vegas -- =
http://devcon.sprintpcs.com/adp/index.cfm
>=20
> _______________________________________________
> Objectbridge-developers mailing list
> Obj...@li...
> https://lists.sourceforge.net/lists/listinfo/objectbridge-developers
>=20