generates the SQL:
which takes 30s on our database, due to the order by. Why this LINQ query does not generate this SQL (without order by) ?
That takes less than one second to execute. In that case we do not want the result in a particular order : we do not care if we get an unordered result set. Actually the performance hit of the order by is so important that it causes timeouts. I understand the idea behind the automatically added OrderBy but this is into relevant to our case. How can we write this query in LINQ without an order by in SQL? If you keep this behavior, it should be documented in manual. |
After some investigation we've started the bug fixing process, the first results are expected to be at the end of the current week. Stay tuned. Thanks! It will help in the cases where we need optimization. The issue is fixed in 4.3 branch. Binaries will be updated shortly. DataObjects.Net 4.3.7 & 4.4 beta 2 is released |