As Ben Forta and others have mentioned via Blog / Discussion groups, etc. Working with lists / string is going to be inherently slower than working with arrays and such. So, read from the XLS and push that data into a 1 dimension array and then remove duplicates, etc (functions available on cflib.org).
On Jan 31, 2008 2:18 PM, Chad McCue <[EMAIL PROTECTED]> wrote: > I have a client uploading a .xls file containing 30k email addresses. I > first need to read that excel file which is fine, reading it with a > excel data source. I then need to parse through to remove all duplicate > emails and then insert into a table. > > My system keeps timing out. The last file that worked had only 6k email > addresses. Anyone know how to handle large lists? > -- http://www.web-rat.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297837 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
