Skip to Content.
Sympa Menu

freetds - Re: [freetds] Having trouble doing a BULK INSERT

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Wes Gamble <weyus AT att.net>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Having trouble doing a BULK INSERT
  • Date: Tue, 07 Nov 2006 09:54:54 -0600

James,

There's no chance that's true, technically. It may save you time, but
it's much, *much* less efficient than bcp or BULK INSERT. You might not
see much difference with 10,000 rows, but with 1,000,000 there's no
comparison.
The most I'll be loading is maybe 50,000 or 60,000. Just writing the file takes most of the time as it stands.

Wes




Archive powered by MHonArc 2.6.24.

Top of Page