I have some code that imports the contents of an Excel
spreadsheet into my database, during the import process I also do a
fair amount of data massaging. When I run this code straight from a
URL it completes in about 90 seconds. When I encapsulate the exact
same code into a CFC function and call it from my Flex application
the run time jumps to around 10 minutes. Is there something about
calling a CFC function from within Flex that I am missing here? The
only differences in the code are a few passed in variables (which
are hard coded in the URL version) and the CFFunction tags. The
differences are trivial so I don't see how they could be accounting
for the extra time.
Any thoughts on why the CFC runs so much slower than the
CFM??? Oh... I am running CF 7.02 and my client will be on that
platform for the foreseeable future. The front end was developed
using Flex 2.0.