Speed up a slow loop
bobsneidar at iotecdigital.com
Fri Mar 4 20:59:07 EST 2022
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
More information about the use-livecode