Hello, all

I am using Criteria and Restrictions.in to load objects. I have 100,000 rows of Thing class, and I want to find those rows whose name is in a set.
Names are strings.

Set set = new HashSet();//put here 5000 names
getSession().createCriteria(Thing.class).add(Restrictions.in("name", set)).list();

And it runs so slow, seems will not stop.
But when I try the same operation directly with JDBC, it runs very fast.

Can anybody give me some suggestions, or is my way insane?

Thanks,

Please check if there are any differences in the H generated sql and the SQL you are executing.
There should be something different to justify such a difference.

As a wild idea: are there enough connections available to Hibernate so it does not get blocked on getConnection somehow.

PS: I made quick experiment with H 3.1.1 and see no difference between JDBC and H SQL and performance