I use method below to do counting of total records in table. I realized there is a slow down when my records in mysql datbase grew. I only need counting no need to assign each record to my Emaillist.class object. I suspend this is not the right way to do counting. What is the best way to do counting?


Criteria crit = sess.createCriteria(EmailList.class,"emailist")
.createAlias("groupMap","groupMap")
.add( Restrictions.like("email", "%"+keyword+"%") )
.add( Restrictions.like("groupId", groupId) )
.add( Restrictions.like("companyId", companyId) ) ;


return crit.list().size();

Hi,

May be use an if condition to reduce the restrictions
Criteria crit = sess.createCriteria(EmailList.class,"emailist")
.createAlias("groupMap","groupMap")
if(keyword != null){
crit.add( Restrictions.like("email", "%"+keyword+"%") )
}
if(groupId!= null){
crit.add( Restrictions.like("groupId", groupId) )
}
if(companyId!= null){
crit.add( Restrictions.like("companyId", companyId) )
}

Let me check for other solution too;-)

The best way to do a count would be to do it:






That'll get you what you're looking for.

Also, i am fairly certain you don't have to do the "%"+keyword+"%" in your clause, the Restrictions.like() functionality should take care of escaping strings for you.

-B