(text/x-fossil-plain)
The SQL query generation for Contains() is very bad for large arrays (it is actually much slower than the query itself). The problem is described here:
https://entityframework.codeplex.com/workitem/245
Entity Framework 6.0 added support for explicit generation of DbInExpression. But as SQLite EF provider does not handle DbInExpression, the feature is not used. Instead, an OR-subtree is back-translated to IN again.
Would it be possible to add proper support for DbInExpression to reduce the query generation time? It should not be too difficult (as far as I can see).
Thank you.
|