I have been having this ongoing battle with large files (3 MB or more). Basically each file is a comma delimited text file that on every line has information that needs to be checked against the database and then either updated or inserted.
Right now I loop through every line in the file and using CFQUERY to do the database check and insert/update. But with the files being 3 MB, it is slow and timesout. The customer is not happy. For the database check I use "IF EXISTS (....) UPDATE .... ELSE INSERT ...." The ISP is using CF Server MX 6 and SQL Server 2000. I cannot use CFFILE for security reasons, they created their own CFX tag to accomodate uploads. So trying to access the file via SQL Server 2000 probably isn't possible. Is there a better way to deal with large files and trying to get them into the database? Any ideas would be appreciated! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280357 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
