April 19th, 2004, 10:40 AM
|
|
Registered User
|
|
Join Date: Mar 2004
Posts: 3
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Which is faster at processing
I've got a question about processing speeds of SQL.
If I have an SQL server with 1 database that has 4 million records in it with a single table that has two fields; field(a) and field(b). I want to take this table and these two fields and add each record together and publish this view onto another SQL server and a different table.
Is it any faster to say write a simple program or script that will take each of the records off of the first SQL, add the two fields and post onto the second SQL server or having SQL do it as a process. Not can it be done, which is faster?
Digatle
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
