308 milliseconds vs. 1590 milliseconds (the numbers were something like that)
This is alot of time saved since the actual application will do 10 times the amount of row inserts.
----- Original Message -----
From: Steve Nelson
To: CF-Talk
Sent: Monday, March 01, 2004 7:00 AM
Subject: Re: SQL Multiple Inserts
I've often wonder at what point Bulk Insert becomes an advantage. I
imagine the drawback with bulk insert is that it has to read an actual
file versus read from ram. It seems that for a small number of records a
regular insert would be faster.
Has anyone done any comparisons between bulk insert versus regular
insert?
Steve Nelson
"Robertson-Ravo, Neil (RX)" wrote:
> Stored Procedure : BULK INSERT.
>
>
>
> _____
>
> From: brobborb [mailto:[EMAIL PROTECTED]
> Sent: 01 March 2004 12:16
> To: CF-Talk
> Subject: SOT: SQL Multiple Inserts
>
> Hey guys, let's say I have to insert like 5,000 rows of data with the
> click
> of a button in my app. Would it be alot faster to insert all 5,000 in
> one
> CFQuery with multiple inserts? Right now it is just one query looped
> 5,000
> times.
>
> Also are there any drawbacks with using multplie inserts?
>
> Thanks
> _____
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
