bcp – clock time meaning
Attempting to BCP a large resultset using a view and the queryout option. I have been playing with the network packet size and the size of the batche using join conditions. When looking at the command line output file. What do the values in "Clock Time (ms.) Total" signify. I am trying to measure the various methods to determine the optimal method. 3,661,051 rows copied Network packet size (bytes): 32576 Clock Time (ms.) Total 239578 Average : (15281.25 rows per sec.)
Software/Hardware used:
sql 2005 enterprise
Software/Hardware used:
sql 2005 enterprise
ASKED:
January 6, 2010 3:55 PM
UPDATED:
January 6, 2010 8:00 PM
Answer Wiki:
Someone anwered the question
Clock Time (ms.) Total is the # of ms taken to execute the bcp....
select (Average)*(Clock Time (ms.) Total )/1000 = rows copied
select 15281.25 *239.578 = 3661051
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
