Re: Search a multidimensional array

2018-04-20 Thread Andrew Bell via use-livecode
THANK YOU for the recommendation! It took 4 seconds to convert this giant array to an SQLlite DB that could be queried in a heartbeat. You just took this project from proof of concept to prototype. My apologies to the list, I vaguely remember seeing that thread but didn't recall the title

Re: Search a multidimensional array

2018-04-20 Thread MWCM via use-livecode
I tried to be a good developer and search the list before posting: multidimensional array search turned up some posts from 2014 but most “sort array” searches only returned single dimensional array options. I just started using encodedArrays on a recent project and fell in love

Re: Search a multidimensional array

2018-04-20 Thread Alex Tweedly via use-livecode
On 20/04/2018 20:15, Richard Gaskin via use-livecode wrote: This is an interesting problem, Andrew.  Thanks for posting it. Indeed! One modest performance gain available easily may be to change this:   repeat for each element tThisItem in tInventoryArray if

Re: Search a multidimensional array

2018-04-20 Thread Richard Gaskin via use-livecode
and few take as long as a second or two for a given query. Either some of what I've learned may help your situation, or your situation will teach me new things to consider. -- Richard Gaskin Fourth World Systems Andrew Bell wrote: Is there a quick way to search a large multidimensiona

Re: Search a multidimensional array

2018-04-20 Thread Bob Sneidar via use-livecode
be a way to import a file based sqlite database into a memory database and then back again for speed. Bob S > On Apr 20, 2018, at 11:32 , Andrew Bell via use-livecode > <use-livecode@lists.runrev.com> wrote: > > Is there a quick way to search a large multidimensional array that I

Search a multidimensional array

2018-04-20 Thread Andrew Bell via use-livecode
Is there a quick way to search a large multidimensional array that I am missing? I'm working on an inventory system and trying to figure out some more efficient methods. Currently I'm taking a tab-delimited spreadsheet provided by the client and converting it to an array