[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
> You can easily eliminate the evaluate() as a factor by replacing
> <cfset field = evaluate("resultSet.#ThisColumn#")>
> with
> <cfset field=resultSet[ThisColumn][resultSet.currentRow]>
> but it doesn't look like you're executing that line enough times to account
> for
> the performance problem.
Actually, for most people, it gets called for every field in every row.
I just did a comparison, and your method works out about the same.. in
one particular drop it did it in 50 seconds where the Evaluate() method
did it in 45 seconds.
I did solve most of my problem by:
#1 - turning the task into an event gateway and having it run asynchronously
#2 - using the java stringbuffer method to generate the drop file.
Rick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250309
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
