The list stuff should work on that many records -- performance might be suspect though.
I'm not sure what exactly was meant by not having the "authority" to put the data in SQL server. It's more of a technicality, but what if you dynamically loaded the data into a temp table or table variable in a cfquery tag and then do your join to that? Overall it might perform better and you wouldn't actually be "putting the data in SQL server" :) ~Brad -----Original Message----- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, December 14, 2007 12:02 PM To: CF-Talk Subject: Re: Compare two tables I had considered the list idea a couple of different ways. I forgot to mention the size of the tables involved. One is ~40,000 records and the other is ~46,000. Are these list ideas going to hold up with lists several tens of thousands of items long? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:294830 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4