bulk insert vs BCP

[Judith Farber Abraham]

Hi,

Which is a faster method -- bulk insert or BCP

And I assume DTS has no problem handling either one? The input files are between 400 meg and 1 gig.

Thanks,
Judith

[Ray Miao]

bulk insert is fastest.


------------
Judith Farber Abraham at 9/12/00 4:05:07 PM

Hi,

Which is a faster method -- bulk insert or BCP

And I assume DTS has no problem handling either one? The input files are between 400 meg and 1 gig.

Thanks,
Judith

[Chris]

I haven't found any benchmarks to substantiate my claim, but in my experience Bulk Insert is faster.

------------
Judith Farber Abraham at 9/12/00 4:05:07 PM

Hi,

Which is a faster method -- bulk insert or BCP

And I assume DTS has no problem handling either one? The input files are between 400 meg and 1 gig.

Thanks,
Judith

[Gary Andrews]

The information I have is that Bulk Insert is about twice as
fast as BCP.


------------
Chris at 9/12/00 4:32:55 PM

I haven't found any benchmarks to substantiate my claim, but in my experience Bulk Insert is faster.

------------
Judith Farber Abraham at 9/12/00 4:05:07 PM

Hi,

Which is a faster method -- bulk insert or BCP

And I assume DTS has no problem handling either one? The input files are between 400 meg and 1 gig.

Thanks,
Judith