when I used LIMIT and offset parameter in my ejbselect , the excution of select is quiet slowly
the dynamic ql looks like:
select Object(g) from Account g ORDER BY g.id OFFSET ?1 LIMIT ?2"
Do you have an index g.id?
Your would get more answers if you post
in the CMP forum.