[AccessD] Speed of bulk insert

"Computers are SUCH a PITA sometimes." JC

...obtuse, even ...the sob's insist on doing EXACTLY what you tell them to 
do, not necessarily what you want them to do :)

William Hindman

----- Original Message ----- 
From: "JWColby" <jwcolby at colbyconsulting.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Wednesday, May 02, 2007 9:08 AM
Subject: Re: [AccessD] Speed of bulk insert


> ROTFL.  If ONLY YOU KNEW!!!
>
> I tried yesterday to do the unzips of the files (a manual process atm) on
> another computer because those operations specifically seem to really tie
> the computer up in knots.  And of course I got crap about "privileges".  I
> can see the files on the server, I just can't do an update / add (unzip) 
> to
> those directories.  But if I go look at the privileges the "everyone" user
> can see and do whatever they want to these directories.
>
> Computers are SUCH a PITA sometimes.
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
> Sent: Wednesday, May 02, 2007 9:02 AM
> To: Access Developers discussion and problem solving
> Cc: dba-sqlserver at databaseadvisors.com
> Subject: Re: [AccessD] Speed of bulk insert
>
> 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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>