Subject Re: [Bulk] [firebird-support] Is Update or Insert more slower than an single Update (or insert)
Author Carlos H. Cantu
It is logical for me, since before inserting, it needs to know if
similar record already exists (to be update). Sso, more operations are
being done (more disk I/O) compared to a single insert.

Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br

VCS> Thanks to my paranoia, i was thinking like everyone that

VCS> Update or insert
VCS> OR
VCS> Insert

VCS> will be close to the same speed (or very similare)

VCS> so i do the test .... and guess ?

VCS> Update or insert is 2x more slower than insert alone :( :( :(

VCS> 100000 Update or insert => 0.501 ms average insert time
100000 insert =>> 0.300 ms average insert time


VCS> sad but interesting to know !



VCS> 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
>>
>>


VCS> [Non-text portions of this message have been removed]



VCS> ------------------------------------

VCS> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

VCS> Visit http://www.firebirdsql.org and click the Resources item
VCS> on the main (top) menu. Try Knowledgebase and FAQ links !

VCS> Also search the knowledgebases at http://www.ibphoenix.com

VCS> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
VCS> Yahoo! Groups Links