[Gretl-devel] Re: Inefficiency in join command?
Am 31.03.2021 um 14:17 schrieb atecon:
In a first experiment I join all series from the RHS dataset by means
of
the wildcard operator:
<join "@NAME_RHS_DATA" * --ikey=datedim,unitdim>
which takes about 5 sec. here.
Then I re-run the experiment by successively increasing the number of
series to join:
<hansl>
loop i=1..nelem(RHS_SERIES_NAMES)
printf "\nInfo: Start joining %d series.\n", $i
flush
strings tojoin = RHS_SERIES_NAMES[1:$i]
set stopwatch
join "@NAME_RHS_DATA" tojoin --ikey=datedim,unitdim
printf "\nInfo: Joining took %.2f sec.\n", $stopwatch
flush
list New = dataset - Base
delete New --force
endloop
</hansl>
As some of you may have noticed, since back in March a feature request
ticket had been created and some discussion took place there
(https://sourceforge.net/p/gretl/feature-requests/151/), although it's
perhaps debatable whether it was instead a mild bug, but anyway.
I believe in current git Allin has worked on fixing this, but I haven't
tested myself yet - part of the reason was that Artur's script above was
not self-contained.
So, Artur, could you test your setup on current git, or alternatively
post a self-contained example for us to test?
thanks
sven