Re: [CFCDev] Upload Tab Delimited file

[Barnaby Relph]

You could try doing almost what you're doing, but build up one large statement then execute that. Just seperate each insert with a semicolon. Running many single inserts will have an overhead compared to one huge one. Oracle almost certainly has native ability to bulk import data, but it's not my area of expertise.   Let us know what works.   Barny ----- Original Message ----- From: Schreck, Tom To: [EMAIL PROTECTED] Sent: Tuesday, December 07, 2004 4:14 PM Subject: [CFCDev] Upload Tab Delimited file What�s the best approach to uploading a tab delimited file using ColdFusion?  I�m working in an Oracle environment and I�m new to Oracle.  So, for right now I have to use ColdFusion.  I am using <cfhttp> to turn file into a recordset.  I�m looping over the recordset and am doing an insert statement for each record.  This is timing out and seems overkill.  Is there a way to do a bulk insert from a recordset into a table?   Thanks - Tom