Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id A928919670C4 for ; Sat, 11 Feb 2012 12:53:34 -0400 (AST) Received: from mout.perfora.net ([74.208.4.194]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RwGCZ-0005D1-RE for pgsql-general@postgresql.org; Sat, 11 Feb 2012 16:53:33 +0000 Received: from genesis.localnet (static.204.116.192.114.spirittelecom.com [204.116.192.114]) by mrelay.perfora.net (node=mrus2) with ESMTP (Nemesis) id 0M6B3i-1SkDJe02Be-00xXp0; Sat, 11 Feb 2012 11:53:17 -0500 From: Terry Lee Tucker To: "pgsql-general@postgresql.org" Subject: Re: question on trigger Date: Sat, 11 Feb 2012 11:53:15 -0500 Message-ID: <1654881.XedbOmu4no@genesis> Organization: The Tucker Family User-Agent: KMail/4.7.3 (Linux/3.0.0-15-generic; KDE/4.7.4; x86_64; ; ) In-Reply-To: <20120211092244.c760ddbd7c0975bc4b045766db7d895c.249dfd1d7d.wbe@email16.secureserver.net> References: <20120211092244.c760ddbd7c0975bc4b045766db7d895c.249dfd1d7d.wbe@email16.secureserver.net> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="nextPart2835566.bgrIHuqkL3" Content-Transfer-Encoding: 7Bit X-Provags-ID: V02:K0:AbJ9jUlwtXnJytHzDUWQ/kjWJO10ngLNpUg2k3Wkcyk Uslr231gDmHxuBi/YLZt8Tc5o+yuepzINXguAuCbWHq01P9kaC DlO1B5/Cbwnb894LdwFDaXrR7LYTbjzkuu691JQg3XFaY/dfVz zncQvQj3iJh/1jpBPJXQ8FyGkI6lg/CSu8rWCgzw9vUTSbz/xh 3FVMsPECqFPFKsGPXMbxiPOJEil9xc2wxqZZyAC0JfAff9Ay7I Ms7u+roEpZ9C4h3cIp3xsQWt25JcVio50OWlNcuoTtogd9RsZO tb5slwNiE/kiBBncX+Myi2jY50jJBMoVor2ftyl2/bCDFW0kU7 eW4K5ZK9Xl7L+dOo5ytY= X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201202/236 X-Sequence-Number: 184748 --nextPart2835566.bgrIHuqkL3 Content-Transfer-Encoding: 7Bit Content-Type: text/plain; charset="iso-8859-1" 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 --nextPart2835566.bgrIHuqkL3 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="iso-8859-1"

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

>= ; I will have several triggers which will make sure that the data in so= me

>= ; columns in in uppercase format.=A0 For insert it is a no brainer, how= ever 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.=A0 In one day we might have at the most 3000 transactio= ns.

>= ;

>= ; Michael Gould

>= ; Intermodal Software Solutions, LLC

>= ; 904-226-0978
--

Mic= hael:

 

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

 

Terr= y Lee Tucker

Office: 336-372-6812<= /span>

 

--nextPart2835566.bgrIHuqkL3--