Array Split vs Combine

Tore Nilsen tore.nilsen at me.com
Tue Mar 9 12:52:02 EST 2021


I got 

248
393
257


also on a Mac


Tore Nilsen


> 9. mar. 2021 kl. 18:40 skrev Sean Cole (Pi) via use-livecode <use-livecode at lists.runrev.com>:
> 
> 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
> _______________________________________________
> 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




More information about the use-livecode mailing list