Below is an excert from a page that uploads an Excel spreadsheet parses it
into a collection and outputs the data from the spreadsheet (actually it
updates a data base, but output is OK for testing).
Anyway, it works OK for twenty or thirty records, but it takes forever to
process when it gets
Below is an excert from a page that uploads an Excel spreadsheet parses it
into a collection and outputs the data from the spreadsheet (actually it
updates a data base, but output is OK for testing).
Anyway, it works OK for twenty or thirty records, but it takes forever to
process when it gets
, 2006 4:34 PM
To: CF-Talk
Subject: HELP: Speeding up a Collection
Below is an excert from a page that uploads an Excel spreadsheet parses
it into a collection and outputs the data from the spreadsheet (actually
it updates a data base, but output is OK for testing).
Anyway, it works OK for twenty
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=
.
Russ
-Original Message-
From: Robert Harrison [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 07, 2006 5:04 PM
To: CF-Talk
Subject: RE: HELP: Speeding up a Collection
I could start putting things like : DONE cfabort / at differt parts
of
the code (of course don't
actually
My guess is COM with java. I would stay inside java and don't venture out
into COM.
It even looks like they use the same methods. Go figure.
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
6 matches
Mail list logo