openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Copeland <t...@jotobjects.com>
Subject Re: Performance issues
Date Fri, 17 Apr 2009 14:55:58 GMT
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