You’re offline. This is a read only version of the page.
I've read the article about the LINQ provider for C#
it seems to me it will take 3 times more to fetch the result when using c# comparing to x++?
Please see the paragraph from the article. If anyone can clarify that would be helpful.
There is an overhead penalty paid at run time, when analysis of the tree occurs, and a suitable access language is generated. As we might expect, the performance penalty is incurred when analyzing the LINQ expression tree. The time required at run time to actually fetch the data doesn't vary much between C# and LINQ versus X++ with while select. Our preliminary numbers show that the beginning-to-end performance of the query is about three times longer with C# LINQ, compared to X++ while select, when very few records are fetched. But when many records are fetched, the total times are about the same between C# and X++. The conclusion is that it takes much longer to fetch a lot of records than it takes to analyze the language tree.
*This post is locked for comments
I have the same question (0)
Share
Report
All responses (
Answers (
4
