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



Reply via email to