Extensions: Projector queries will fail with more than 2000 result nodes


Because of the limitation of the IN() clause.

Possible solutions:
  • Divide the query into multiple INs when there are more than, let's say, 1000 ids.
  • Use "temporary table": have a table that just contains temporal rows of the selected ids for joining. This is possible with IRepository<T> but building the temporal dataset can be very expensive (N objects inserted first) despite the JOIN then being better performing than the large INs. Also to properly adapt to the changes of the underlying data this temporal dataset should be built with every query...
Closed Jun 7, 2013 at 9:57 PM by Piedone


Piedone wrote Jun 7, 2013 at 9:54 PM

Fixed in changeset 7ed84aad7a2b