Array Split vs Combine

[Ralph DiMola]

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