You you using a data loader native to the db, or are you inserting the records one at a time? Native loaders generally have a way to prevent duplicates. If you're inserting one at a time, just do a query first to see if it exists. You'll definitely want an index on that column, possibly even a unique index.
On Thu, May 22, 2008 at 4:10 PM, Les Mizzell <[EMAIL PROTECTED]> wrote: > I've got an application that a client uses to import email list from > Excel spreadsheets into a database for use to send e-newsletters to > specific groups. > > The database has grown quite large, and when importing list to specific > group at this point, they're forgetting if a particular email address > had already been added, and needs something that prevents duplicates > from being added to the list. > > I can think of a couple of clumsy (resource intensive) ways to check the > addresses being imported against what's already in the database, but > there must be an optimal way to do it. > > <cf_check_duplicates_before_insert> ?? > > Suggestions? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305947 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
