| Subject | Re: [Bulk] [firebird-support] Is Update or Insert more slower than an single Update (or insert) |
|---|---|
| Author | Carlos H. Cantu |
| Post date | 2012-01-14T18:51:34Z |
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:
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
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:
>>VCS> [Non-text portions of this message have been removed]
>> Hello,
>>
>> Is "Update or Insert" more slower than an single Update (or insert) ??
>>
>> thanks by avance
>> stéphane
>>
>>
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