Hi

I have a table with three columns. It contains 30,000 records. When I am trying to retrieve all these records. It is taking 20 minutes. It doesn't contain any primary key.

When I retrieve the same from JDBC, it is taking less than a minute.
Here the database exists remotely.

How to reduce the retrieval time?

Thanks
NavaJyothi

any comments on the above problem?

plz do post peace of code u do in hibernate and as well as in jdbc.

List<Users> events = null;
SessionFactory sf = HibernateUtil.getSessionFactory();
Session session = sf.openSession();
session.beginTransaction();
long startTime = System.currentTimeMillis();
try {
Query query = session
.createSQLQuery(
"select * from Users")
.addEntity(Users.class);
events = query.list();
} catch (Exception queryException) {
session.getTransaction().rollback();
} finally {
session.getTransaction().commit();
session.close();
}
long endTime = System.currentTimeMillis();
System.out.println("Time Taken:"
+ (((endTime - startTime))));
return events;

I'm not sure but you can try these two things.

1. Criteria API
Criteria c=createCriteria(Stock.class)
List <Stock> stock=c.list();

2. If u have child tables you can use this in your native sql query.
select s.* from Stock s in native sql.

Please show the SQL Hibernate executes.

select * from USERS
I have also tried giving individual columns

Hi shaikeliasmca,

I have tried yours. Even for that it is taking 19 minutes. Any other things you want me to try?

Hi shaikeliasmca,

I have tried yours. Even for that it is taking 19 minutes. Any other things you want me to try?

http://www.developersfusion.com/Default.aspx