Hi.
I had a quick look at paging implementation in cayenne. If i understand it correctly it uses IncrementalFaultList to load object in such way thet it only loads ObjectId-s for the whole list, and uses them to load whole records when needed.
I'm not sure this is happening because log indicates all columns are selected.
Many databases implement ways to limit portion of the dataset directly in select query statement, in different ways (by using top keyword and where, or first and skip statements or whatever)
I would like to only get portion of records directly for select. Could this be implemented in another IncrementalFaultList that would use select translators for specific databases that support this functionality?
What else would be needed to support this?
As Chris would say (I think), am i smoking crack?
---------------------------------
Relax. Yahoo! Mail virus scanning helps detect nasty viruses!
This archive was generated by hypermail 2.0.0 : Wed Feb 08 2006 - 07:05:25 EST