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. _______________________________________________ use-livecode mailing list email@example.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode