Subject | Re: [Bulk] [firebird-support] Is Update or Insert more slower than an single Update (or insert) |
---|---|
Author | Vander Clock Stephane |
Post date | 2012-01-14T12:40:51Z |
Thanks to my paranoia, i was thinking like everyone that
Update or insert
OR
Insert
will be close to the same speed (or very similare)
so i do the test .... and guess ?
Update or insert is 2x more slower than insert alone :( :( :(
100000 Update or insert => 0.501 ms average insert time
100000 insert => 0.300 ms average insert time
sad but interesting to know !
Update or insert
OR
Insert
will be close to the same speed (or very similare)
so i do the test .... and guess ?
Update or insert is 2x more slower than insert alone :( :( :(
100000 Update or insert => 0.501 ms average insert time
100000 insert => 0.300 ms average insert time
sad but interesting to know !
On 1/13/2012 6:53 PM, Vander Clock Stephane wrote:
>
> Hello,
>
> Is "Update or Insert" more slower than an single Update (or insert) ??
>
> thanks by avance
> stéphane
>
>
[Non-text portions of this message have been removed]