Fastest way to check if a record Exists ??? (HOW)

bengrant · **Joined:** Wed Sep 13, 2006 7:24 am **Posts:** 26

Using Hibernate 3.1.3

What would be the fastest way (performance/memory wise) to check the existance of a record.

a basic method would be to do a

Code:

   private boolean idExists(Session session, String id) {
        List list = session.createQuery("From Stuff s where s.idCol = :id1")
        .setString("id1", id)
        .setReadOnly(true)
        .setFetchSize(1)
        .setCacheable(true)
        .list();
        return (list.size() > 0) ;
    }

but is there a faster way of doing this ? I have 2nd level caching turned on with EnCahce

Thanks

lvildosola · **Posted:** Thu Dec 07, 2006 10:13 am

Hibernate Tips & Tricks suggest to use UniqueResult. That's what I use.