I want to perform an incremental load on my manticore search table, can someone help me please?
I have a table that migrates data once a day, but with manticotre what we do is a --rotate indexer and this migrates all the 9 million data always when it should migrate only the 2 thousand new records and the 100 edited records, that’s it I mean with incremental loading, so I don’t know how I can achieve that in manticore search, please help
What you are looking for is the main + delta schema.
Interactive course - Manticore Search - Main+delta schema
Docs - Manticore Search Manual: Data creation and modification > Adding data from external storages > Main delta