Brian, Thanks for the post. The times between rc2 and 1.0, I believe, are actually to new PersistentFieldIntrospectorImplNew. If you're not using that, you should and you'll see an even bigger diff. That setting can be changed in OJB.properties
HTH R P.S. Did you post this on Hibernate list??? :-) On 8/9/04 8:57 AM, "Mcgough, Brian Joseph" <[EMAIL PROTECTED]> wrote: > 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 > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
