The whole problem is that this is a mailjob application that allows our clients to upload huge txt files with email addresses and other relevant information to our server along with some html files that gets processed and then sends out the emails.
CF DOES NOT SEND THE ACTUAL EMAILS!!!!! I have a FreeBSD box running Perl that takes care of that portion. CF is merely used for the administration interface. The reason why I needed the information was to offer our clients a possibility to make a follow-up campaign where an email was sent out to the users that didn't read the first mail. I Think I'll try to process the txt files against the statistic table in Perl. Thanks for the input! @llan -----Original Message----- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 12:27 PM To: CF-Talk Subject: Re: Simple question .... QueryOfQuery > Thanks for you input Justin, > > But I think I need to find a workaround .... in a typical case of this page > the original list holds 30-90.000 addresses .... and the partial list > contains 0-90.000 addresses ..... needless to say that this query takes > forever... > Hmmm... With that number of records in a text file its always going to be slow.... I'd be tempted to load the records from the text file into the database, which will take some time, and then write a suitable outer join query to get the records that aren't in your second table. Hope this helps regards Stephen ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
