Re: AW: Speed of fetching simple entities using OpenJPA

2011-09-23 Thread M. Walter
or using a different database? -- View this message in context: http://openjpa.208410.n2.nabble.com/Speed-of-fetching-simple-entities-using-OpenJPA-tp6784781p6824183.html Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: Speed of fetching simple entities using OpenJPA

2011-09-13 Thread M. Walter
.html Entity generation is very time consuming Unfortunately I haven't found a solution to speed up things yet... -- View this message in context: http://openjpa.208410.n2.nabble.com/Speed-of-fetching-simple-entities-using-OpenJPA-tp6784781p6786834.html Sent from the OpenJPA Users mailing list

AW: Speed of fetching simple entities using OpenJPA

2011-09-13 Thread Michael Pflueger
@openjpa.apache.org Betreff: Re: Speed of fetching simple entities using OpenJPA Hi Michael, I had a similar question about this topic. Reading 6 rows and converting them into entities needs 24 seconds (using OpenJPA 1.2.3). This is quite a long time in my opinion. Take a look: http://openjpa.208410.n2

AW: Speed of fetching simple entities using OpenJPA

2011-09-13 Thread Michael Pflueger
- Von: Michael Pflueger [mailto:michael.pflue...@sma.de] Gesendet: Dienstag, 13. September 2011 15:29 An: users@openjpa.apache.org Betreff: AW: Speed of fetching simple entities using OpenJPA Hi, attached is a zip containing both the OpenJPA and JDBC tests to read the entities, and a small prog

Speed of fetching simple entities using OpenJPA

2011-09-12 Thread Michael Pflueger
Hi, I compared JDBC and OpenJPA speed of fetching simple entities (consisting only of a single ID attribute). The speed difference seems quite severe. With JDBC, I can read 2 million entities in about 3 seconds when OS/DB caches are warm. With OpenJPA using slice (a single slice), it takes a

Re: Speed of fetching simple entities using OpenJPA

2011-09-12 Thread Rick Curtis
Michael - I wouldn't expect to see that large of a difference of JPA vs JDBC. Can you describe your scenario a little better? Are you issuing just a single JPQL to select all of your Entities? Thanks, Rick On Mon, Sep 12, 2011 at 1:36 PM, Michael Pflueger michael.pflue...@sma.dewrote: Hi, I

Re: Speed of fetching simple entities using OpenJPA

2011-09-12 Thread Rick Curtis
quickly. Michael -Ursprüngliche Nachricht- Von: Rick Curtis [mailto:curti...@gmail.com] Gesendet: Montag, 12. September 2011 20:44 An: users@openjpa.apache.org Betreff: Re: Speed of fetching simple entities using OpenJPA Michael - I wouldn't expect to see that large of a difference