> -----Original Message----- > From: Gaulin, Mark [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 28, 2004 11:54 AM > To: CF-Talk > Subject: RE: Dumb Question About CFPARAM > > You might squeak out a bit of performance by making a stored procedure out > of it and using an "optimistic update" strategy... Just do the update and > if the record count is zero then do an insert. This will completely > remove the select. > (I guess you don't need a sp for this.)
I've toyed wit the idea for a while... but probably won't do it this time. The queries involved are just so completely simple (selects against primary keys, then updates or inserts) that I just can't see much (if any) of a boost to be gained there. There just doesn't seem to be much bang for the buck. Changing the calls as I did (using single statements instead of multiple CFQUERY tags) seems to have helped slightly (perhaps a 5-10% performance gain). It's not a silver bullet, but I'll take it. ;^) Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188882 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
