Michael Dinowitz wrote: > > Can I see any stats you have backing this up or the steps you took. I'd like > to test it out more. Thanks >
Stats... no. 1) Any data I have is strongly protected by the 'ol company 2) Tests were about a year ago, don't have the data Steps... Yeah, I think I can help, but I'm no kind of DBA. Basically, you load the SQL Profiler, point it out to your SQL Server and watch it fly. You should see calls to sp_prepare and sp_unprepare. >>We've seen the same behavior with client variables, so we don't use them. > > DB based client vars? I've been using them for a long time with no > performance problems (that I've seen). On SQL Server 2000? We had big problems. I'm guessing it has to do with traffic, but I don't know how much hof gets compared to mine. I think I heard Sarge say that MM.com doesn't use client vars for performance reasons. Can't remember exactly. It makes sense though, that's a lot of extra database activity when most of the work could be done manually with better performance. > What of a CFQUERY call to a SP where the variables being passed to the SP > are written using the CFQUERYPARAM? Have you tried this? I don't use cfqueryparam with exec sp_ calls, I figure it's redundant. Would be interesting to find out though. Steve Nelson was doing some testing like this a few months ago, but I think he may have missed this case. -nathan strutz http://www.dopefly.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188466 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
