Rob, I just put some testing together over lunch:
http://www.bennadel.com/blog/200-ColdFusion-CFHttp-To-Query-Much-Faster-Than -Java-Buffered-Reader.htm I was comparing CFHttp to Java input for speed. It doesn't sound like you can use query-type data... But you might want to take a look at the Java code to see if you can tweak it. The Java was surprisingly slow but I was adding a query record per data row. Anyway, thought I would try to help as much as I could (with limited Java skills). ...................... Ben Nadel www.bennadel.com -----Original Message----- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 08, 2006 12:40 PM To: CF-Talk Subject: Parsing a file I know this has been asked before, but I can't seem to find this in the archives. I have a file that I am doing a ton of parsing on. It's has fake encryption (basically obsfucation) and I am doing a ton of listgets and going through each line and putting it into a structure. The thing is it's only a 1.7mb file, but it's bringing my pretty beefy server to its knees. DTS and Microsoft SQL server and even sql_loader for Oracle is not an option as I am basically decrypting this file. Anyone have any ideas on what i can do to make this process leaner? Bob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:249237 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
