Best Way to Update Table?
From: Rachan Terrell (web24by7_at_hotmail.com)
Date: 04/09/04
- Next message: Vishal Parkar: "Re: Delete higher price record, if there is one."
- Previous message: Hari: "Re: Drop User Command"
- In reply to: chris: "Best Way to Update Table?"
- Messages sorted by: [ date ] [ thread ]
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.
>.
>
- Next message: Vishal Parkar: "Re: Delete higher price record, if there is one."
- Previous message: Hari: "Re: Drop User Command"
- In reply to: chris: "Best Way to Update Table?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|