Invoke Method Within Another Method
Hi,
I have a question regarding invoking a method within a another method. That is, returning a resultset to another function.
For example:
<cffunction name="test" returnType="query">
<cfquery name="something" cachewithin="0,0,3,0">
blah...blah...
</cfquery>
</cffunction>
<cffunction>
<cfinvoke method="test" returnvariable="something" argumentcollection="#ARGUMENTS#">
followed by some additional Q of Q.
</cffunction>
Essentially, I am trying to reuse a central query process as much as possible. This works great until I move it to a production environment. It seems the production server is hanging and is prone to crashing. Initially, I was thinking it may be a server leak or memory issue. I do not have access to this server for monitoring/testing. The development and production environments are not the same. I know the production database has more data. I went ahead and changed the above code where I am not returning a resultset from another function, but generating it within the same function and am getting much better performance. Is the above method just slow...and not the best way to do things or do you think there are memory issues with the production server?
Thanks
