Is there a performace difference here?

BrendanKim · **Posted:** Thu Nov 02, 2006 5:23 pm

Hi, I'm using Hibernate 2.1.7 now, and wonder the uses below make really a difference in performance. Thanks a lot for the answer in advance.

1. sesssion.get(MyData.class, new Long(getId()))

2. session.createCriteria(MyData.class).add(Expression.eq("id", getId())).uniqueResult()

BK

MikePloed · **Posted:** Fri Nov 03, 2006 4:36 am

I doubt that there is a big difference in the performance.

baliukas · **Posted:** Fri Nov 03, 2006 10:03 am

"sesssion.get" must be better, it must execute SQL generated on startup, "session.createCriteria" will build it for every call.

BrendanKim · **Posted:** Fri Nov 03, 2006 11:23 am

I understand the second case can include caching control as follows. Can this be a good advantage then? I'm assuming get() cannot provide query result caching.

session.createCriteria(MyData.class).add(Expression.eq("id", getId())).setCacheable(true).uniqueResult()

Thanks again.

baliukas · **Posted:** Fri Nov 03, 2006 11:52 am

"get" and "load" must cache result if cache is enabled in class mapping (see "<cache/>" tag)

gopalsaha · **Joined:** Tue Feb 24, 2004 11:42 am **Posts:** 56

if caching is enabled get will first look into the cache and then into db if it does not find in entity cache. criteria will fecth it from querycache if query cache is enabled else it will be slow as it will have to make a db call.So there is difinitely a performance issue.
hope this helps and if so please do rate