| Subject | Re: Odp: [firebird-support] Performance diff between insert...select and for select ... do? |
|---|---|
| Author | Kjell Rilbe |
| Post date | 2015-04-14T07:44:35Z |
'=?utf-8?B?bGl2aXVzbGl2aXVzQHBvY3p0YS5vbmV0LnBs?='
liviuslivius@... [firebird-support] skrev:
been no more than marginally better. Even merge does have to do an index
lookup for each record to check if one exists or not, doesn't it? Or
does it ignore the index lookup and simply add a new record version
regardless?
Furthermore, even the straight insert (with PK and indices
dropped/inactive) was orders of magnitude slower than the proprietary
text file I resorted to (no surprise really).
Regards,
Kjell
--
------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
liviuslivius@... [firebird-support] skrev:
>Yes, indeed. Might have been worth a shot, but I suspect it would have
> Why not merge?
been no more than marginally better. Even merge does have to do an index
lookup for each record to check if one exists or not, doesn't it? Or
does it ignore the index lookup and simply add a new record version
regardless?
Furthermore, even the straight insert (with PK and indices
dropped/inactive) was orders of magnitude slower than the proprietary
text file I resorted to (no surprise really).
Regards,
Kjell
--
------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64