Why would you want to load record across network
Let’s say I have array with 100 elements.
I query with array get 100 record
do a distinct values get 100 elements voila you are done
do a distinct value and get 99 records OH OH you have as problem
you might also query index not sure of
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
I would modify as follows
set query destination into a variable
query table
check variable
You might also query with array
distinct values. If records in selection count = query with array count and
distinct values count also equals, you have only one record each
Regards
Chuck
Try both ways with a timer... but my money is on Query table without the use
set.
Let us know.
Neil
--
Privacy Disclaimer: This message contains confidential information and is
intended only for the named addressee. If you are not the named addressee you
should not disseminate,
4 matches
Mail list logo