> I could start putting things like : "DONE" <cfabort /> at differt parts of
the code (of course don't
> actually update the database). See if you can narrow down which part of
the algorithm is taking a long time.
Been there and done that ALL DAY... The bottle neck lies either here:
<CFSET objRange=
objSheet.Range("A#cnt#,B#cnt#,C#cnt#,D#cnt#,E#cnt#,F#cnt#,G#cnt#,H#cnt#,I#cn
t#,J#cnt#,K#cnt#,L#cnt#,M#cnt#")>
or here:
<cfset
record[#listgetat(column_headers,collection_cnt,",")#] = this.text>
I suspect the latter. It seems like Excel is extreamly slow, but this is
2006. CF should have no problem parsing an Excel sprearsheet even it has
thousands of records.
Thanks,
Robert Harrison
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:259534
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
