'=?utf-8?B?bGl2aXVzbGl2aXVzQHBvY3p0YS5vbmV0LnBs?='
liviusliv...@poczta.onet.pl [firebird-support] skrev:
>
> Why not merge?
Yes, indeed. Might have been worth a shot, but I suspect it would have
been no more than marginally better. Even merge does have to do an index
lookup for each record to c
'=?utf-8?B?bGl2aXVzbGl2aXVzQHBvY3p0YS5vbmV0LnBs?='
liviusliv...@poczta.onet.pl [firebird-support] skrev:
>
> Why not merge?
>
Yes, indeed. Might have been worth a shot, but I suspect it would have
been no more than marginally better. Even merge does have to do an index
lookup for each record to
Hi,
Why not merge?
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Kjell Rilbe kjell.ri...@datadia.se [firebird-support]"
Do:
Temat: [firebird-support] Performance diff between insert...select and for
select ... do?
Data: wt., kwi 14, 2015 07:08
Kjell Rilb
Kjell Rilbe kjell.ri...@datadia.se [firebird-support] skrev:
>
> Hi,
>
> I'm writing a utility that will need to do two things for each record in
> an external table and for this purpose I use a for select ... do
> construct in an execute block. I do it this way because external tables
> can't be i
Mark Rotteveel m...@lawinegevaar.nl [firebird-support] skrev:
>
> On 13-2-2015 14:55, Kjell Rilbe kjell.ri...@datadia.se
> [firebird-support] wrote:
> > I'm writing a utility that will need to do two things for each record in
> > an external table and for this purpose I use a for select ... do
> >
On 13-2-2015 14:55, Kjell Rilbe kjell.ri...@datadia.se
[firebird-support] wrote:
> I'm writing a utility that will need to do two things for each record in
> an external table and for this purpose I use a for select ... do
> construct in an execute block. I do it this way because external tables
>
Hi,
I'm writing a utility that will need to do two things for each record in
an external table and for this purpose I use a for select ... do
construct in an execute block. I do it this way because external tables
can't be indexed and I will scan the entire external table anyway.
The two opera