Michael Dinowitz wrote: > 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.
Our traffic was in the ~3 mil+/day on that box back then, turning updates off helped, but didn't fix. I've been meaning to create a client var replacement someday, but haven't found the time yet. > 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? None others that I can think of. I found Steve Nelson's old blog entries on the subject: http://www.google.com/search?q=site%3Asteve.secretagents.com+cfstoredproc Parts 1 & 2 should be the first 2 links. -nathan strutz http://www.dopefly.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188484 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
