My app is displaying a list of possible objects to load. Currently I am retrieving the whole object (but that seem like a waste of bandwidth and a speed hit).
Coming from a SQL background, I know you can select only the fields you want from a row.
Lets say the table has 4 fields,
owner:String,
date_created:Date,
date_modified:Date,
BIG_BINARY:byte array (1000 times larger then the rest of the data).
select owner, date_created from myTable where owner = me
I know I can filter on owner = me, but is it possible reduce the amount of data?
Another way to do this would be to have the data link actually go to another table where the binary resided, but that is kind of ugly.
Nice thing is this saves both users, and YGN from having to download the BIG_BINARY object unless its needed...
bob