Part 4 – Getting data; Can you SELECT() something faster?
What does adding a Select() do?
One ability that OData offers is the ability to reduce the result set for the request using a Select() command. This can reduce the number of columns in a result set from 100 to just 5. This can be used to provide only required data for a given request. However, does this really work as expected from a performance perspective? So far we have focused on SQL and…
One ability that OData offers is the ability to reduce the result set for the request using a Select() command. This can reduce the number of columns in a result set from 100 to just 5. This can be used to provide only required data for a given request. However, does this really work as expected from a performance perspective? So far we have focused on SQL and…
Continue Reading Nathan Clouse’s Article on their blog
Part 4 – Getting data; Can you SELECT() something faster?
What does adding a Select() do? One ability that OData offers is the ability to reduce the result set for the request using a Select() command. This can reduce the number of columns in a result set from 100 to just 5. This can be used to provide only required data for a given request.
Blog Syndicated with Nathan Clouse’s Permission
More About This Author
Array
- Finance & Operations17 March 2024Does Specifying Columns in Select Statements Matter?
- Finance & Operations16 March 2024Copilot for F&O is here in Preview
- Finance & Operations25 February 2024Using Git in PackagesLocalDirectory – VS 2022 Edition
- Finance & Operations25 February 2024Using Git in PackagesLocalDirectory – VS 2019 Edition