Hi,
I am not sure I know how to answer that. Even without the upload of the file
(reading the file from the server) the page takes 60 sec to parse 80k file. I
don't know if it's the part that converts it into a query, the part that loops
over and parse each record of the query or the part that inserts the parsed
results into different tables. I just look at the debug code and see the page
took 60 sec to run.
Right now I insert the data as I loop over the query. Would it be better to
build a struct for each table then insert the entire struct at one time for
each table?
_____
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
To: CF-Talk [mailto:[EMAIL PROTECTED]
Sent: Sat, 25 Aug 2007 05:58:18 -0400
Subject: Re: CF 7 parse large EDI file
David Brown wrote:
>
> I need to import a large 2 megs or so 271 EDI file into sql tables. EDI files
> are not fun to parse, but I have it working fine. The problem is speed. It is
> slow to me... 61 sec to parse 80k file (171 records).
>
> Any ideas on how to improve it?
Which part of it is slow?
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287154
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
