[AccessD] Speed of bulk insert

Gary Kjos garykjos at gmail.com
Wed May 2 08:01:39 CDT 2007


Now you just need to train your SETI array of PC's to all work on it together.

GK

On 5/2/07, JWColby <jwcolby at colbyconsulting.com> wrote:
> Interestingly, the speed of import has either - jumped from ~1K records /
> second to about 11K records / second, OR - I previously missed a decimal
> place (though the times required earlier on were still quite large so I
> don't think that's it).  In any event ATM I am getting a speed consistently
> around 11K / second for a bulk insert operation.  That is a significant
> event in my ability to expeditiously process 100 million records.
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Gary Kjos
garykjos at gmail.com



More information about the AccessD mailing list