I'll run some tests one of these nights. As for traffic, we only get about 35k page views a day so it may be a traffic thing. On the other hand, I turn off the constant update of client vars which saves a LOT of overhead. I'm going to run the different types of calls and get some results. Correct me if I'm wrong but we have 1. CFQUERY straight 2. CFQUERY straight with CFQUERYPARAM 3. CFQUERY on a SP 4. CFQUERY on a SP with CFQUERYPARAM 5. CFSTOREDPROC
Any others? > -----Original Message----- > From: Nathan Strutz [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 21, 2004 4:00 PM > To: CF-Talk > Subject: Re: CFStoredProc bug? > > 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:188471 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
