openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Leangen <k...@leangen.net>
Subject Re: Performance issues
Date Mon, 20 Apr 2009 04:49:59 GMT

Thank you, I'll give that a try.



On Fri, 2009-04-17 at 07:55 -0700, Paul Copeland wrote:
> That sounds interesting.  You might turn on verbose logging for SQL 
> operations (openjpa.jdbc.SQL) and see what queries are actually being 
> executed. The logging section of the OpenJPA manual explains this.
> 
> On 4/17/2009 3:41 AM, David Leangen wrote:
> > Hello,
> >
> > I'm not at all an expert in databases, so I don't know if this is a JPA
> > thing or a DB thing.
> >
> > In any case, I'm using Postgresql. Using the findAll( Class,
> > Collection ) method, I am doing a  lookup by PK. Since there is an index
> > like so on the table:
> >
> >    "table_pkey" PRIMARY KEY, btree (id)
> >
> > I would have expected the lookup to be very fast.
> >
> > With a collection of about 100 ids, the lookup takes almost 30 seconds,
> > which does not seem right to me.
> >
> >
> > Any ideas where I should begin to look?
> >
> >
> > Thanks!
> > =David
> >
> >
> >
> >
> >
> >   
> 


Mime
View raw message