microsoft dynamics - Select Statement Vs Find in Ax -
while writing code can either use select statement or select field list or find method on table fetching records.
wonder of statement helps in better performance
it depends on need.
find()
methods must return whole table buffer, means, of columns projected buffer returned it, have complete record selected. need single column, or few. in such cases can waste select whole record, since won't use columns selected anyway.
so if you're dealing table has lots of columns , need few of them, consider writing specific select statement that, listing columns need.
also, keep in mind select statements project few columns should not made public. means should not extract such statements method, because imagine surprise of consuming method , trying figure out why column x empty...
Comments
Post a Comment