Touche! On 2/6/14 11:23 PM, "Byron Mann" <byronos...@gmail.com> wrote:
> >Need to update that, the Case statement would update every row where gom = >'maze'. Even those rows not needing to be updated. > >Byron Mann >Lead Engineer & Architect >HostMySite.com >On Feb 6, 2014 11:17 PM, "Byron Mann" <byronos...@gmail.com> wrote: > >> Depending on your table size, indexing and number of rows actually being >> updated, it may be better to just wrap all the updates into a >>transaction. >> >> BEGIN TRAN; >> >> UPDATE...... >> UPDATE...... >> UPDATE...... >> .... >> COMMIT TRAN; >> >> The case statement example may not be optimal, as it will update every >>row >> unnecessarily. Not nice if you have a million row table and only need to >> actually update 30 rows. >> >> Multiple OR statements is probably better, as you will be restricting >>the >> update to the required rows, but might be hard to read for debugging. >>Plus >> too many ORs and performance may be more optimal with multiple updates. >> >> I usually find the simple the better. >> >> Byron Mann >> Lead Engineer & Architect >> HostMySite.com >> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3540 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
