Yeah, I'm trying to remember if I heard the overhead issue somewhere on this list or if it was at MAX but whoever said it seemed fairly reliable and they said the overhead was substantial when building the query objects in CF. Let me know if you produce any reliable numbers or if you come up with a clear-cut solution.
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:43 PM To: CF-Talk Subject: RE: Extra query info 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. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:190806 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
