This project is read-only.
1

Closed

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

description

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 10:57 PM by Piedone

comments

Piedone wrote Jun 7, 2013 at 10:54 PM

Fixed in changeset 7ed84aad7a2b