[AccessD] Speed of bulk insert

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

Which is still better than the wife.  She insists on doing what she THOUGHT
you were asking her to do, which does not even remotely resemble what you
actually ASKED her to do, never mind what you really wanted done.

<ducks hastily behind the asbestos barrier>

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 William Hindman
Sent: Wednesday, May 02, 2007 9:27 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
> 



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com