Thread: question on trigger

question on trigger

From
Date:
<table align=3D"center" style=3D"empty-cells: show;" bgcolor=3D"#ffffff" bo=
rder=3D"0" cellpadding=3D"0" cellspacing=3D"0" width=3D"100%"><td style=
=3D"text-align: left; background-repeat: no-repeat;" align=3D"left"; height=
=3D"72" colspan=3D"1" background=3D"cid:top@a48f3ca396eea5d068ebd27bcb06ebf=
d"<div style=3D"padding: 5=
px; overflow-x: auto;"><span style=3D=
"font-family:Verdana; color:#000000; font-size:10pt;">I will have seve=
ral triggers which will make sure that the data in some columns in in upper=
case format.  For insert it is a no brainer, however for updates, it i=
s better to check and see if the new values is the same and only update if =
different? We are not talking about a huge number of transactions.  In=
 one day we might have at the most 3000 transactions.</d=
iv>Michael GouldIntermodal Software Solutions, LLC<di=
v>904-226-0978=
=

Re: question on trigger

From
Terry Lee Tucker
Date:

On Saturday, February 11, 2012 09:22:44 AM mgould@isstrucksoftware.net wrote:

> I will have several triggers which will make sure that the data in some

> columns in in uppercase format.  For insert it is a no brainer, however for

> updates, it is better to check and see if the new values is the same and

> only update if different? We are not talking about a huge number of

> transactions.  In one day we might have at the most 3000 transactions.

>

> Michael Gould

> Intermodal Software Solutions, LLC

> 904-226-0978
--

Michael:

 

I am by no means an expert on database performance; however, it seems to me that you would waste more cycles checking if things changed than simply forcing upper case for all to which this criteria applies. The whole record is going to be written to the database anyway.

 

Terry Lee Tucker

Office: 336-372-6812