Speed up a slow loop

[Bob Sneidar]

Well… the idea was, if storing and working with the data as arrays was crucial, then I have a method for creating sqLite databases, memory or otherwise, from arrays and then back again. I don’t know if mobile devices can use memory databases, or perhaps the data is too much for mobile device limits, so I am sailing murky waters there. But once the overhead of iterating through the array once is spent, recursive querying of a memory or even a file database is much more efficient.  

Sent from my iPhone

> On Mar 4, 2022, at 15:16, Neville Smythe via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> Bob’s suggestion of storing the word list in an sqlite database would keep the list on disk and not in memory