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"