On 4/5/2018 7:31 PM, gadelkareem wrote:

Because there's only one value for that property.

If the deltaQuery returns a million rows, then deltaImportQuery is going
to be executed a million times.  Once for each row returned by the
deltaQuery.

That IS as inefficient as it sounds.  Think of the dataimport handler as
a stop-gap solution -- to help you get started with loading data from a
database, until you can write a proper application to do your indexing.

Thanks,
Shawn