You could do TRANSACTION , or if that is overkill for the situation
set the order to the index do a count and if less than reccount() do a reindex.