Do you use the SQL Profiler to monitor your sql server? (This is not the stuff in Query Analyzer... it's a standa-alone app that shows all queries (filterable) as they are executed.) I have found it to be extremely useful in finding both slow and also often-used queries... some of the quick ones are run so frequently that even saving a page fetch or two with each one feels worth it. SQL Profiler can be "fun" to get configured just right, but it's very powerful.
-----Original Message----- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 28, 2004 12:48 PM To: CF-Talk Subject: RE: Dumb Question About CFPARAM > -----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:188885 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
