JWColby
jwcolby at colbyconsulting.com
Tue May 1 09:48:36 CDT 2007
There is a BATCHSIZE parameter to BULKINSERT. Does anyone know the effects (speed-wise) when using this parameter? What is a reasonable value for this parameter? I did not use a BATCHSIZE in the first file imported, but I set a batchsize =10000 (10K) for the next file. These import files can be anywhere from a couple of hundred thousand records up to 4 million records. John W. Colby Colby Consulting www.ColbyConsulting.com