Performance: rs.update vs if
Hi,
maybe one of you knows this (hope this question is not too stupid):
A recordset is open (function imports data from another database), where 10 fields of a record may have been changed by the user. Ususally at one Session only a very small percentage of the records in fact have been changed, and only one or two fields.
I could check if there was a change,
and update only if thats true, or I could update every record.
My question now is: Which Idea should have a higher performance?
have a nice day,
Patzer
have a nice day
Patzer
_____________________________
Philo will never be forgotten