Search Values of Array in "One Go"

[Alex Tweedly]

On 23/08/2017 20:07, Sannyasin Brahmanathaswami via use-livecode wrote:
> Bob, Mike,
>
> thanks…"use the dbase" good thought
> ...
>
> So then it comes down to whether doing a query semi-complex query that looks at 50,000 records and uses  %like% against 3 columns is faster than iterating loops on a 1000 key array already in memory.
>
3 columns ?  I thought it was :
> and 30+  more "properties" for the media item
So, 3 or 30+ ? Probably make a difference ...

Alex.