On Jan 19, 2008, at 11:59 PM, Andrus Adamchik wrote:
When I remove setPageSize, caching works, so it's paradoxically
better
than with paging. With paging, on every page cayenne retrieves full
table + records relevant for the page.
Yes, the cache settings are skipped for paginated queries for
various technical reasons (except for the ROP scenario that Ari
mentioned - it was hand coded for this case)... although I think we
should make it work in all situations...
BTW, fixing that now:
https://issues.apache.org/cayenne/browse/CAY-967
After this is fixed, LOCAL_CACHE will work with paginated results, but
not the SHARED_CACHE.
Andrus