Array Split vs Combine

Sean Cole (Pi) sean at pidigital.co.uk
Tue Mar 9 12:40:23 EST 2021


Extraordinary. Thanks Alex. This is helpful. This is on windows and a
windows server. I will try on a Mac and Linux and see if it has the same
issue.

Sean

On Tue, 9 Mar 2021 at 17:25, Alex Tweedly via use-livecode <
use-livecode at lists.runrev.com> wrote:

>
> On 09/03/2021 16:56, Sean Cole (Pi) via use-livecode wrote:
> > Hi all,
> >
> > I have a tsv I split out as an array, process, then combine back to a
> tsv.
> > The tsv is 53MB (55,635,198 bytes) and has 228320 lines with 21 columns
> > (55406878 chars).
> >
> > To load the tsv file : 434ms
> > To split the tsv to array : 506ms
> > To combine the array to a tsv : 2m 58s 214ms
> >
> > Why does it take so much longer to combine than split?
>
> No idea. It *doesn't* for me.
>
> I get timings of
>
> 367 725 919
>
> (on my aging MacBook Pro)
>
> Alex.
>
> > Link to the file:
> > https://www.dropbox.com/s/r6aq3ysbj13o16o/Enhanced-GB.tsv?dl=0
> > Test code:
> >
> > *put* the millisec into tTime1
> > *put* url("file:Enhanced-GB.tsv") into tTest
> > *put* the millisec into tTime2
> > *split* tTest using cr and tab
> > *put* the millisec into tTime3
> > *combine* tTest using cr and tab
> > *put* the millisec into tTime4
> > *put* tTime1,tTime2,tTime3,tTime4
> >
> >
> > Sean
> > _______________________________________________
> > use-livecode mailing list
> > use-livecode at lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
-- 
Pi Digital



More information about the use-livecode mailing list