Sorry about the slow reply. > found out that moving the cursor over 60000 rows takes 14 seconds! Well that is good news for OpenJPA!
I will note that JPA wasn't designed for these sort of mass load (ETL)[1] situations. It sounds like for this scenario we're going to be good enough, but if you continue down the track you are, at some point JPA (most/all providers) won't do quite what you are looking for. [1] http://en.wikipedia.org/wiki/Extract,_transform,_load On Mon, Jul 18, 2011 at 6:40 AM, M. Walter <marc.wal...@sbb.ch> wrote: > Okay I tried loading the data with plain JDBC. I found out that moving the > cursor over 60000 rows takes 14 seconds! So I can't blame JPA for taking so > much time. Well at least that's how Oracle 11g performs. Maybe there are > other faster databases. > > -- > -- *Rick Curtis*
