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

> 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
same?

-- 

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