Hello,
this is just an idea, not tested nor verified, but I'd like to know your opinion.

The iterate method returns list of found objects - it fetches primary keys from the databse of objects to be further retrieved.

select id from table where some_condition

Then, when some object in the iterator is to be used, query is issued to fetch the properties of the object using the following query.

select field1,field2,field3 ... from table where id=123141241

It seems OK, but how about in concurrent environment.
What if the record id=123141241 no longer satisfies the some_condition?

Obviously, one gets object that no longer satisfies the query conditions.
Perhaps, it is ment to be up to the developer to be careful in such situation, but then it should be stressed in documentation that this might happen.

Any comments welcomed.

Marcel

Depends upon isolation level. If you care, use repeatable read.