Re: [Bulk] [firebird-support] Is Update or Insert more slower than an single Update (or insert)

Vander Clock Stephane wrote: Thanks to my paranoia, i was thinking like everyone that Update or insert OR Insert Well, it is called UPDATE OR INSERT, and not INSERT OR UPDATE. As you can see, update comes first. -- Milan Babuskov == The easiest way to

Re: [Bulk] [firebird-support] Is Update or Insert more slower than an single Update (or insert)

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 -

Re: [Bulk] [firebird-support] Is Update or Insert more slower than an single Update (or insert)

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. i was thinging than during an update or insert, the engine try first to insert the record ... and