Informix dialect and limited select

amitev · **Joined:** Sat Sep 09, 2006 11:01 am **Posts:** 6

Hi all! I used setFirstResult and setMaxResults with informix but Hibernate generate query "select first ... from" and when the results are retrieved it iterates them and returns as list only the records from the first to maxresult size. That is working well but i think that i`ll be more fast when the query is generated like "select skip :first first :size * from ..."

scarface · **Joined:** Sun Jun 04, 2006 1:58 am **Posts:** 136

You can use SQL query option or

Subclass InformixDialect

Quote:

http://www.hibernate.org/hib_docs/v3/api/org/hibernate/dialect/InformixDialect.html

and overide getLimitString method