Hibernate Community • View topic - Query from hibernate running slow

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Query from hibernate running slow

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

rajnishe

Post subject: Query from hibernate running slow

Posted: Fri Nov 26, 2010 6:36 am

Newbie

Joined: Fri Oct 14, 2005 7:52 am
Posts: 9
Location: delhi

I am running one query from mysql then it is running fine but when run from application it takes time .
Any clue .

Top

rajnishe

Post subject: Re: Query from hibernate running slow

Posted: Tue Nov 30, 2010 1:31 am

Newbie

Joined: Fri Oct 14, 2005 7:52 am
Posts: 9
Location: delhi

I am using code as :

List list = getHibernateTemplate().find(query, params);

retunr list.size();

It is taking a lot of time .

Thanks to please help.

Top

CDillinger

Post subject: Re: Query from hibernate running slow

Posted: Tue Nov 30, 2010 12:24 pm

Senior

Joined: Tue Oct 28, 2008 10:39 am
Posts: 196

rajnishe wrote:

I am using code as :

List list = getHibernateTemplate().find(query, params);

retunr list.size();

It is taking a lot of time .

Thanks to please help.

You know "select count(*) from..."?
You are reading all rows into memory and count there.

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum