On 4/5/2018 7:31 PM, gadelkareem wrote:
Why the deltaImportQuery uses "where id='${dataimporter.id}'" instead of
something like where id IN ('${dataimporter.id})'
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
