What factors control which columns from a record are brought down to the client? If a form only contains two columns will only two columns be brought down? What other factors can control how many columns are brought down?
Do the same rules apply to both smartclient and webclient?
Dean
The only way to prevent column data to be loaded into memory is marking the columns as excluded. Then they won’t be available in Servoy no matter what, except if you manually query for them.
Otherwise, if a row in the table is touched, all the data in the columns will be downloaded.
Paul
Otherwise, if a row in the table is touched, all the data in the columns will be downloaded.
except for blob columns, right?
pbakker:
…if a row in the table is touched, all the data in the columns will be downloaded.
When looping with
for(var i = 0; i <= foundset.getSize(); i++)
{
foundset.getRecord(i);
}
is that considered “touching” or is touching only when data is displayed on a form?
Dean
except for blob columns, right?
No, they are included as well.
is that considered “touching” or is touching only when data is displayed on a form?
Yes, that is considered touching the record as well.
Paul