In SQL server, for example, a varchar field triggers a delete/insert update under certain cirumstances (if the varchar value is larger than it was before or if the varchar is part of the primary key). This kind of update takes longer than the usual "update in place" update.
Reply With Quote