hm ok, Im a spoilt Oracle kid 😉
well, for the indices (idx) – if its just an auto-increment, that doesnt mean its bound to be complete? as in – without gaps?
its does not need to be, anyhow.
Then, for a fresh scan (not full) the new items would have the highest idx, wouldnt they?
A full rescan kinda kills most of those since the date_added gets reset, doesnt it ? 😉