|
cross-posting from slack for posterity:
Interesting read per the discussion of whether to (eventually) support query compilation in the Entity Framework Provider.
TL;DR:
- the author showed only ~10-20% mean improvement in speed for simple queries.
- Performance converged on about the same speed as queries became more complex (as more clauses were added to the filter)
- "If you really need the performance of the query, it's better to focus on running the query rather than optimizing the compilation. Try to run the full query, and improve it with indexes, fewer joins between tables, retrieving only the necessary values, etc..."
|