An alternative solution would be to import the file into a DB temp table and use a stored procedure to compare the two. Much faster than CF processing it alone.
How often do you need to do this? Is it real time - is the end user waiting for the info as it's processed? If it's a behind-the-scenes task the stored procedure should be fine. -----Original Message----- From: Justin Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 5:59 AM To: CF-Talk Subject: Re: Simple question .... QueryOfQuery > 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... If speed is an issue, I would suggest using something other than CF for this operation to generate the list of addresses you require. A compiled program will be able to do something like this much faster than CF will, esp with that much data to process. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
