[hibernate-users] Hibernate Performance against Progress Open Edge database

Hi All, I know that I am comparing apples to oranges here. But I am surprised to find that a simple Hibernate query ("from Photoset p") takes 4 times as much time as JDBC. I know that there is overhead involved with the benefits that Hibernate offers. But don't you think 4 times is just too slow? Please let me know if there is a way to get a better performance out of Hibernate. Thank you! Here are the results: # Records: 5000 # Mapped Columns: 2 Hibernate Query / Plain JDBC: 560 ms / 150 ms # Mapped Columns: 3 Hibernate Query / Plain JDBC: 1200 ms / 270 ms # Mapped Columns: 5 Hibernate Query / Plain JDBC: 1680 ms / 390 ms Thanks, Joe /* Hibernate Code */ Session session = sessionFactory.openSession(); Transaction tx = session.beginTransaction(); Date beginTime = new Date(); Query query = session.createQuery("from Photoset p"); List<Photoset> photosets = query.list(); System.out.println(photosets.size() + " photoset(s) found:"); Date endTime = new Date(); tx.commit(); session.close(); System.out.println("Total Time Taken: " + (endTime.getTime() - beginTime.getTime()) + " ms"); /* Photoset.hbm.xml - Hibernate Mapping file */ <hibernate-mapping> <class name="Photoset" table="pub.fotoset"> <id name="id" column="fotosetnum"> <generator class="sequence"> <param name="sequence">pub.nextfotosetnum</param> </generator> </id> <property name="title" column="fotosettitle" /> </class> </hibernate-mapping> /* Photoset.java */ public class Photoset { private Long id; private String title; Photoset() {} public Photoset (String title) { this.title = title; } public Long getId() { return id; } public void setId(Long id) { this.id = id; } public String getTitle() { return title; } public void setTitle(String title) { this.title = title; } } /* JDBC Code that runs 4 times faster */ Date beginTime = new Date(); PreparedStatement pstmt = con.prepareStatement("select fotosetnum, fotosetitle from pub.fotoset"); ResultSet rs = pstmt.executeQuery(); int numFotosets = 0; while (rs != null && rs.next()) { Photoset photoset = new Photoset(); photoset.setId(rs.getLong(1)); photoset.setTitle(rs.getString(2)); numFotosets++; } rs.close(); System.out.println("# Photosets:" + numFotosets); Date endTime = new Date(); System.out.println("Total Time Taken: " + (endTime.getTime() - beginTime.getTime()) + " ms");