Best Way to Update Table?

From: Rachan Terrell (web24by7_at_hotmail.com)
Date: 04/09/04


Date: Fri, 9 Apr 2004 11:08:11 -0700

Chris,

Use BCP to extact the data to a text file then write perl
program to update the BCP file. Then BCP it back.

Otherwise, brake the table into 4 tables and then process
it in 4 differant servers and then merge them back.

Hope this help...if not send me an email.

GoodLuck,
Rachan

>-----Original Message-----
>Hello,
>
>I have a large table of data. 120million rows, 250
fields
>in each row. The important fields in the table for the
>update are phone (phone number) and phone_pander_flag
>(flag the is Y or N indicating if the person wants to be
>called or not).
>
>The data used to updated this large table is in a second
>table that is basically just a bunch of phone numbers.
>There are 64million phone numbers in this list.
>
>What I want to do is for every phone number in the
update
>table (the 64million numbers), I want to check the main
>table (the 120million record table) for that phone
number
>and if there is a match, switch the phone_pander_flag to
>a 'Y'.
>
>So far, the fastest I've gotten this to run is 50hrs.
>There must be a faster and better way.
>
>Let me know.
>
>Chris.
>.
>



Relevant Pages