1 Reply Latest reply on Aug 27, 2003 12:43 AM by Takenori Sato

    Is page-size the number of records queried

    pclerides Newbie

      I have instances where I am doing a read-ahead on-find strategy with a page-size of 4.

      For one EJB it does a select for 4 keys: select from table where pk=1 and pk=2 and pk=3 and pk=4.

      For another EJB it does: select from table

      The example in the CMP book uses a page-size of 4 and the result set has seven rows.

      What I need is one query: select from table. There are only 700 rows and I only need the name.

      Can anyone shed any light on this behaviour? I am using 3.0.6.

      Sorry for possibly not having the proper terms I am not at the office and have access to my code.