Re: Sorting text is *VERY* slow in LC9 on Windows (Re: Accumulating text is *VERY* slow in LC9 on Windows)

2021-09-13 Thread Ben Rubinstein via use-livecode
Thanks Mark, now I get it! Ben On 12/09/2021 12:09, Mark Waddingham via use-livecode wrote: On 2021-09-10 19:10, Ben Rubinstein via use-livecode wrote: The other was The only caveat is that it might cause apps mutating lots of medium->large strings concurrently to take up more memory in

Re: Sorting text is *VERY* slow in LC9 on Windows (Re: Accumulating text is *VERY* slow in LC9 on Windows)

2021-09-12 Thread Mark Waddingham via use-livecode
On 2021-09-10 19:10, Ben Rubinstein via use-livecode wrote: The other was The only caveat is that it might cause apps mutating lots of medium->large strings concurrently to take up more memory in general... > ... (and any issue arising from that could be resolved by moving to the 64-bit

Re: Sorting text is *VERY* slow in LC9 on Windows (Re: Accumulating text is *VERY* slow in LC9 on Windows)

2021-09-11 Thread J. Landman Gay via use-livecode
Ah yes, the cheese thing. I so wish I had saved that thread, but I may have needed an extra backup drive to do it. So listen, and ye shall hear. Long, long ago in the olden days, before there was a forum, before 64-bit apps, back when the QCC reports numbered in the lower hundreds, someone on

Re: Sorting text is *VERY* slow in LC9 on Windows (Re: Accumulating text is *VERY* slow in LC9 on Windows)

2021-09-11 Thread Lagi Pittas via use-livecode
I thought Mark was misremembering Emmental when he said Edam (they do start with an E) but I believe Venezuelan Beaver Cheeses is probably a better analogy as it has many holes caused by the beavers' sharp incisors. and is a bit of a mystery (very difficult to acquire) as is the workings of

Re: Sorting text is *VERY* slow in LC9 on Windows (Re: Accumulating text is *VERY* slow in LC9 on Windows)

2021-09-10 Thread scott--- via use-livecode
Yes, it did mention cheese... but it was entirely on topic and about LiveCode. (How could Mom not approve.) -- Scott Morrow Elementary Software (Now with 20% less chalk dust!) web https://elementarysoftware.com/ email sc...@elementarysoftware.com booth1-360-734-4701

Re: Sorting text is *VERY* slow in LC9 on Windows (Re: Accumulating text is *VERY* slow in LC9 on Windows)

2021-09-10 Thread Bob Sneidar via use-livecode
I’m going to propound on the politics of holey cheese makers in a moment! Sent from my iPhone > On Sep 10, 2021, at 11:16, J. Landman Gay via use-livecode > wrote: > > You're talking about cheese. I'm telling Mom. Nyah. > > -- > Jacqueline Landman Gay | jac...@hyperactivesw.com >

Re: Sorting text is *VERY* slow in LC9 on Windows (Re: Accumulating text is *VERY* slow in LC9 on Windows)

2021-09-10 Thread J. Landman Gay via use-livecode
You're talking about cheese. I'm telling Mom. Nyah. -- Jacqueline Landman Gay | jac...@hyperactivesw.com HyperActive Software | http://www.hyperactivesw.com On September 10, 2021 8:42:48 AM Trevor DeVore via use-livecode wrote: On Fri, Sep 10, 2021 at 8:15 AM Mark Waddingham via

Re: Sorting text is *VERY* slow in LC9 on Windows (Re: Accumulating text is *VERY* slow in LC9 on Windows)

2021-09-10 Thread Ben Rubinstein via use-livecode
Hi Mark, Thank you for this, very promising. Only two things puzzled me. One you've already addressed when you corrected the specified cheese. The other was The only caveat is that it might cause apps mutating lots of medium->large strings concurrently to take up more memory in general... >

Re: Sorting text is *VERY* slow in LC9 on Windows (Re: Accumulating text is *VERY* slow in LC9 on Windows)

2021-09-10 Thread Jim Lambert via use-livecode
Cheddar, Edam and Swiss! Very daring references on this list. ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

Re: Sorting text is *VERY* slow in LC9 on Windows (Re: Accumulating text is *VERY* slow in LC9 on Windows)

2021-09-10 Thread Trevor DeVore via use-livecode
On Fri, Sep 10, 2021 at 8:15 AM Mark Waddingham via use-livecode < use-livecode@lists.runrev.com> wrote: > On 2021-09-10 14:06, Mark Waddingham via use-livecode wrote: > > The windows heap is much more prudent than UNIXy counterparts it would > > seem - where UNIX heaps will happily leave plenty

Re: Sorting text is *VERY* slow in LC9 on Windows (Re: Accumulating text is *VERY* slow in LC9 on Windows)

2021-09-10 Thread Mark Waddingham via use-livecode
On 2021-09-10 14:06, Mark Waddingham via use-livecode wrote: The windows heap is much more prudent than UNIXy counterparts it would seem - where UNIX heaps will happily leave plenty of free space (which the heaps know about and thus can re-use), Windows appears to avoid that like the plague

Re: Sorting text is *VERY* slow in LC9 on Windows (Re: Accumulating text is *VERY* slow in LC9 on Windows)

2021-09-10 Thread Mark Waddingham via use-livecode
On 2021-09-02 18:38, Mark Waddingham via use-livecode wrote: We will endeavour to fix for 9.6.5-rc-1 (due 'real soon now'!). So I have been prodding the windows 'accumulating large strings' speed problem this week (in amongst other things). It is definitely memory allocation causing the

Re: Sorting text is *VERY* slow in LC9 on Windows (Re: Accumulating text is *VERY* slow in LC9 on Windows)

2021-09-03 Thread Ben Rubinstein via use-livecode
I'm very much hoping that Mark W might magically fix this in 9.6.5. But in the meantime FWIW, the place where this was really hurting (in a script that took 8 minutes under LC6, was taking 8 hours under LC9, but I've gradually tamed it down to under an hour by buffering the large

Re: Sorting text is *VERY* slow in LC9 on Windows (Re: Accumulating text is *VERY* slow in LC9 on Windows)

2021-09-02 Thread Bob Sneidar via use-livecode
I am going to say no, because you still have to traverse the file once to get it into sqLite, then do the sort, then write out the file when done. I might be mistaken, the subsequent SQL sort may make up for lost time. Using a memory SQL really shines when you need to make multiple passes at

Re: Sorting text is *VERY* slow in LC9 on Windows (Re: Accumulating text is *VERY* slow in LC9 on Windows)

2021-09-02 Thread Bernard Devlin via use-livecode
Whilst waiting for a fix, would a temporary solution be to use sqlite to create an in-memory database and let sqlite do the sorting for you? Regards, Bernard. On Mon, Aug 30, 2021 at 8:23 PM Ben Rubinstein via use-livecode < use-livecode@lists.runrev.com> wrote: > Thanks to Mark Waddingham's

Re: Sorting text is *VERY* slow in LC9 on Windows (Re: Accumulating text is *VERY* slow in LC9 on Windows)

2021-09-02 Thread Mark Waddingham via use-livecode
On 2021-08-30 20:22, Ben Rubinstein via use-livecode wrote: Thanks to Mark Waddingham's advice about using a buffer var when accumulating a large text variabel in stages, I've now got a script that took 8 hours under LC9, and (8 minutes under LC6) down by stages to just under 1 hour under LC9.

Sorting text is *VERY* slow in LC9 on Windows (Re: Accumulating text is *VERY* slow in LC9 on Windows)

2021-08-30 Thread Ben Rubinstein via use-livecode
Thanks to Mark Waddingham's advice about using a buffer var when accumulating a large text variabel in stages, I've now got a script that took 8 hours under LC9, and (8 minutes under LC6) down by stages to just under 1 hour under LC9. However I have some remaining issues not amenable to this