i am using the following query to limit the columns to return from a table
Dim var = From o As comp.Business.Objects.User In comp.Business.Objects.UserCollection.RunSelect Select o.PKID, o.FullName, o.login
In performance terms, does this run the select statement with only the columns i define ?
Or does it get the entire result set and then filter the columns from the select statement ?
Just asking to know if i am gaining the performance from limiting the select statement.
I know about components and views to define in the model but i need to set the select statement at run time , without going to the model.