Is page-size the number of records queried

[pclerides]

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.

Thanks,

[takenori]

Hi,

That sounds not like a problem about strategy.

SELECT (DISTNCT) name_column
FROM your_bean

This simple query don't solve your problem?

Takenori