What do you mean "in memory"? And was your DB running on the same hardware as CF? The DB has to do the same work in either case (some randomization of a million rows), so the overhead of the SP/query should be completely lost in the mass of time it'd take to deal with the data.
cheers, barneyb On 10/30/05, Justin D. Scott <[EMAIL PROTECTED]> wrote: > > You mention SP's will give greater performance. I > > think that may be a myth these days. Google around > > and you will find all sorts of debates on it. I was > > shocked myself after spending a good bit of day > > taking some queries from a CF page and dumping them > > into a shiny new stored proc and things didn't > > improve and actually seemed to slow down some. > > In my experience, it depends on the data you're querying against and how it > is to be used. One example I had was a table with 1,000,000+ rows that had > to have random data pulled out of it about once every 3 to 5 seconds, and > more at peak hours. Even with the proper indexes and the entire table in > memory, the one query being run from ColdFusion with one variable was eating > up 75% of the processor on average, and closer to 90% during peak. > > Converting that one query to a SP and passing the variable to it knocked the > CPU usage on the CF server down to about 5% on average. It really did help > a LOT. If you're working with smaller tables that don't get a lot of > traffic, you probably won't notice much of a difference, if any. > > > -Justin Scott -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222684 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
