Current setup:
Running a query on one datasource which creates a list of emails.
Insert records into another datasource:
First attempt:
Loop over list and do an insert for each email_address
Second attempt:
Insert into table1 (value1, value2)
Select value1, value2
>From table2
Where id in (list_passed from first query)
Table2 is a copy of the initial table that the first query was run on
datasource1
This works ok for smaller lists, but as that grows (up to 100k records) it
just hangs.
Any SQL tips out there on how to accomplish this in a much more efficient
way?
Thanks in advance,
Phil
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
