Folks; playing with Solr and an existing (legacy) RDBMS structure which we can't change much, I am trying to figure out how to best make Solrs full/delta import work for me. A few thoughts:
(a) The usual tutorials outline something like WHERE LASTMODIFIED > '${dih.last_index_time} in order to select what needs to be re-imported. So far I didn't manage to figure out which other informations the DataImportHandler does expose. In my case, something like WHERE ID > '${dih.last_indexed_id} definitely would help as objects are just added to that very structure and the ID is an auto-increment; however I couldn't find whether DataImportHandler supports such an approach. (b) I see that "last_index_time" returns a particularly fixed format. In our database, with a modestly more complex SELECT, we also could figure out which entities have been changed using some protocol table which includes timestamps in seconds since EPOCH. Is there some way of retrieving such a timestamp from DataImportHandler or will I have to do so somehow on my own? Thanks in advance and all the best, Kristian