All,
I just wanted to share some data points that were recently collected
that compare OJB and Hibernate and the ability to scale with both.
We had a data file with only 10,000 records in it that we needed to load
into our database. Typically we use our batch environment, but given
that we are a java shop now, we wanted to see if we could use java and
our ORM tool to get the job done.
We started out using Hibernate for this, and we found that we had some
real problems. It just would not scale whether or not we were using
transactions. We found that it would take greater than 17 hours to load
only 7500 of the records. Obviously this is unacceptable performance,
and so we thought to try the same thing using OJB.
I am happy to report that using OJB we were able to load the whole file
of 10,000 in under 12 minutes.
In addition to this, we just recently upgraded a project from OJB 1.0
rc2 to OJB 1.0 and I am happy to report that for that particular project
db performance was improve by a factor greater than 10. This is mostly
due to the new implementation for FieldAccess.
I just wanted to thank the developers for their attention to detail in
regards to ensuring that the overhead above jdbc was minimal, and for
all of the tests that they have written to ensure that is the case. We
are very happy that we are still able to use ORM for this instead of
straight jdbc, because the rest of the application is written using the
ORM.
Anyway I just wanted to share these points with the group, for those of
you that are out there and are on the sidelines as far as which
framework will scale better.
Brian McGough
IU - UITS - UIS - SIT
(812) 856-4871
