batch update for snapshot table, prevent too much copying