On Wed, Sep 21, 2016 at 10:44 PM, Chip Scheide <4d_o...@pghrepository.org>

> Table has about 150k records
> query with array is performed on table
> a number of records are in selection, but always <100.
> record data is in cache.
> Client/Server
> It is necessary to step through the selection to insure that only one
> record exists
> for each array element in the query with array, and if true, do some
> processing.
> Which is faster/better?
> is there a difference?
> Query([table][table]index_Field=value)
> or
> use set
> Query selection([table];[table]Indexed_field=value)

Not sure I understand problem, but why you want to use query at all? You
can sort selection, step through records and check if any two items are


Peter Bozek
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com

Reply via email to