Array Split vs Combine

[Sean Cole (Pi)]

It's looking to be a Windows only issue. I need to see how far this goes
back and then I'll post a bug report. It's making a process that should
only take 30s max on a single thread 2GHz remote Win server take 16mins to
process 2 of these files, so it will be good to find a solution for this.

Thanks everyone for confirming and providing your input.

Regards
Sean

On Tue, 9 Mar 2021 at 18:06, Ralph DiMola via use-livecode <
use-livecode at lists.runrev.com> wrote:

> LC 9.6.1 Win 10 VM on SSD.
>
> 524 ms,512 ms, 3.28 minutes
>
> Ralph DiMola
> IT Director
> Evergreen Information Services
> rdimola at evergreeninfo.net
>
> -----Original Message-----
> From: use-livecode [mailto:use-livecode-bounces at lists.runrev.com] On
> Behalf
> Of Sean Cole (Pi) via use-livecode
> Sent: Tuesday, March 09, 2021 11:56 AM
> To: How to use LiveCode
> Cc: Sean Cole (Pi)
> Subject: Array Split vs Combine
>
> 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?
>
> 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
>