And in general, don't use lists for large amounts of data. A list with 15,000 elements is generally not a good idea at all. Remember, lists are not a true type (like arrays are, for example). A list is a string, and extracting values, or traversing the list, or manipulating it in any way, requires lots and lots of string parsing and processing for each operation. Lists are great in that they are how data comes back from HTML forms, and how SQL IN clauses accept data, and are therefore perfect for those situations. But lists should generally not be used as a data storage type.
--- Ben -----Original Message----- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 30, 2008 11:26 AM To: CF-Talk Subject: RE: Duplicates in Arrays or Lists Put the values in a Struct; in one pass you can create a second array/list that avoids any values that are already in the Struct. Mark -----Original Message----- From: Chad McCue [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 30, 2008 11:16 AM To: CF-Talk Subject: Duplicates in Arrays or Lists Anyone have a function that runs that will remove duplicates from a list or array. My list will have over 15k items so I need it to run as fast as possible. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:297747 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
