Hi,
I think when you use setStartIndex method, all the results are retrieved
from DB and then your query returns only the subset that you specified.
I ran into that problem too and I had to add an additional criteria to my
query :
Criteria crit = new Criteria();
crit.addSql("rownum < 100");
Query q = QueryFactory.newQuery(Foo.class, crit);
Collection c = broker.getCollectionByQuery(q);
The problem is that it uses oracle specific stuff.
But at least, performance is much better !
Hope that helps,
Thomas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
