The performance of a CFC that has been set as an object is very good. I'd have to say extremely good with a 0ms hit on most occasions. As for a performance hit when building/altering queries, I've never heard of one but I'll do some tests to be sure. A query 'object' is just like an array 'object' or structure 'object'. They're all just data collections. On the other hand, a QoQ does have some overhead but that's due to it having a whole query parsing engine and all. Not a lot of overhead in most cases, but it's not as efficient as some things (like struct functions).
> Michael, > > I don't know if this will play into it at all, but I seem to remember > some people talking about performance hits when you build new queries or > add columns/data to existing queries using the query functions in CF. > The method of using a CFC to format the data and return a new query > object may have bad performance in that realm if what I've heard is > true. Also, once you create the CFC as an object, you should be able to > make as many calls as you want to it without nearly as much overhead. I > have no data to back that up, but from what I've heard, that seems like > it'd be the case. If I'm wrong, I'd love to hear about it. > > > John Burns > Certified Advanced ColdFusion MX Developer > AI-ES Aeronautics, Web Developer > > -----Original Message----- > From: Michael Dinowitz [mailto:[EMAIL PROTECTED] > Sent: Monday, January 17, 2005 12:29 PM > To: CF-Talk > Subject: Extra query info > > Here's a conceptual question. Lets say you have a query with multiple > rows in it. There is a few calculations that will take place between > items in a row to get some additional values per row (i.e. a discount > price, etc.). > One way of doing this is when outputting the query, you send the > specific data to a CFC (It's used in multiple places) and get out a > structure. This means that a 20 row query has 20 calls to the CFC. > Another way of doing it is to pass the whole query to a CFC which will > then loop over the query, do the calculations and then place the results > into new columns within the query. > The first has a single loop but multiple CFC calls while the second has > 2 loops (inside the CFC and out) but a single CFC call. > Which do you prefer? Do you see a problem with either approach? > Just something that came into my mind while rewriting a few dozen pages > on this ecommerce site. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190789 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
