In DataImportHandler, is it possible to use the prior maximum value of
the PrimaryKey in the delta query, as opposed to (or in addition to)
using "dataimporter.last_index_time"? We already have Created_On and
Updated_On fields, but we've only indexed the Updated_On fields. I was
hoping for something like

SELECT column1,column2 FROM t_table WHERE Updated_On >
{dataimporter.last_index_time} OR table_primary_key >
{dataimporter.last_max_primary_key}

I'd hate to add an index on Created_On just so it could track new rows
since the last run, when the maximum primary key could easily catch
those rows.

Reply via email to