1 Reply Latest reply on Jun 6, 2003 1:19 PM by Adrian Brock

    why the 'limit' and 'offset' make myfiner quiet slowly

    godspeedwang Newbie

      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"