Just a guess but... If you are doing a lot of string manipulation CF can be really slow. I don't know about CF 8 as I have not tried parsing large text strings with it, but earlier versions were abysmal performance wise when it came to string manipulation.
As far as CFC's and objects go, I have seen plain old cfquery and cfoutput run ten+ times faster than doing the same thing by loading a bean with data and passing it to a DOA or Gateway. Even with CF 8. Based on my experience, I would imagine that the bottle neck would be in one of those two places. Again just a guess. G! On Sun, Oct 17, 2010 at 11:14 PM, Bryn Parrott < bryn_parr...@internode.on.net> wrote: > > Dear All, > > I have this algorithm that runs a query or two against a mySQL (5) database > on a Win 2003 (64Bit) server. The code loops over the query; assembles some > text and writes it out to a text file line by line. Fairly simple really. > There are lots of records. > > When I code this algorithm and execute in PHP 5 it runs in 7 seconds (give > or take); > When I code and excecute it in CF 8.0.0, it runs in around 74 seconds. > > The PHP code is being executed using cfexecute... > > Now to me this kind of performance degradation/difference between PHP and > CF is unintuive, given that PHP is interpreted; whilst CF is 'compiled'; I > expected CF to run faster. > > This was not my code to begin with however I have gone over it and checked > for all the usual suspects; memory leaks; var variables and the like. > The CF code is in the form of a cfcomponent, and my execution time > observations were taken on the second run to take the compilation phase into > account. > > Now I'm aware that CF 8.0.1 fixed some performance issues relating to CFC > methods (I think...); but were the issues as severe as I am seeing ? > > Anyway, have others any views to offer on why I am seeing such a severe > performance degradation for CF over PHP and suggest any way in which I might > tune the CF code/server so that it is more nearly the same or better than > the PHP. Sonme might suggest this is difficult since I have deliberately > not posted the code; however I'm thinking that perhaps you might suggest > general things I may not have thought of. > > Thanks, > Bryn > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338268 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
