Re: Result in cfquery

[Tom Chiverton]

On Thursday 19 Jun 2008, Randy Johnson - CFConcepts wrote:
> Would putting result="qryResults"  in my  tags cause any
> performance hits 

Yes, because CF will check the result type at runtime every single request.
This is almost certainly such a small hit you'll not care though.

> Any thoughts?

If you really need to do this without a step debugger, why not just use CFFILE 
and CFSAVECONTENT to write the CFDUMP of the query to disk ?

-- 
Tom Chiverton



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office. Any reference 
to a partner in relation to Halliwells LLP means a member of Halliwells LLP.  
Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.com.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307822
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Result in cfquery

[Randy Johnson - CFConcepts]

Hello,

Would putting result="qryResults"  in my  tags cause any 
performance hits or excess memory usage?

I was thinking of creating a script that could be used on our production 
server to show some debugging information since we do not have debugging 
turned on.

I was thinking it would work something like this:


Select fname,lname,email from contacts;


And then in the Application.cfc  using onRequestEnd  to check to see if 
the debug flag was checked







Any thoughts?

-Randy

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307733
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4