0 Replies Latest reply on Nov 24, 2003 4:18 PM by Amit

    One Finder method executing  many queries

    Amit Newbie

      I have a custom finder method "SELECT OBJECT(o) FROM Store AS o WHERE o.Id=?1".

      Server is executing n (number of records which match the sql criteria) +1 queries.

      How can I avoid this, so that I can get every thing back in first query.

      Is "read-ahead" only solution?

      thanks in advance.