Attempting to BCP a large resultset using a view and the queryout option. I have been playing with both the network packet size and the size of the batch using join conditions. When looking at the command line output file. What do the values in "Clock Time (ms.) Total" really 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.)
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