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

Reply via email to