> -----Original Message----- > From: Gaulin, Mark [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 28, 2004 1:05 PM > To: CF-Talk > Subject: RE: Dumb Question About CFPARAM > > 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.
Yes - of course in my case (shared hosting) I can only use it on the development server, not production (gawd how I'd love to run a trace on production!) due to permission issues. ;^) This is exactly the reason that I spent yesterday combining several simpler CFQUERIES into single (but slightly more complex) Transact SQL Statements. We save just the time in transit, but still that improved those processes by about 5-10%. For example I had (in several places in the Session Manager) something like: Query to see if a key exists, if no rows do an insert, if rows do an update. I replaced those with Transact SQL "EXISTS" based IF statements. Just to trim as much network latency as I could from the beast. It wasn't a silver bullet, but I'm confidence that the application is generally just about as optimized as its going to get... but every little bit helps. 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:188888 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
