Subject | do I need to compare in this trigger... |
---|---|
Author | csswa |
Post date | 2002-04-10T17:59:31Z |
for a trigger than silently prevents changes to a field before
update, which is the speediest of these two:
1. if new.pk <> old.pk then new.pk = old.pk
2. new.pk = old.pk
Is doing the comparison slower than simply doing version 2 every time?
Regards,
Andrew Ferguson
update, which is the speediest of these two:
1. if new.pk <> old.pk then new.pk = old.pk
2. new.pk = old.pk
Is doing the comparison slower than simply doing version 2 every time?
Regards,
Andrew Ferguson