Does placing a CFQUERY in a CFC rather than in code bring about much of a performance boost? % improvement? Does Cached Within still work if placed inside CFC? I understand stored procedures are more efficient - but in this case it is a complex dynamic query so I dont want to put in Stored Procedure.
So is it now a better practice to put CFQUERY as a CFC? I have a lot of 15 year old code CF - so just wondering?
I have CF 11 SQL server 2012