Is there any way to limit the results of a query on the "from" index before it
gets joined?
The SQL analogy might be...
SELECT *
from toIndex join
(select * from fromIndex
where "some query"
limit 1000
) fromIndex on fromIndex.from=toIndex.to
Example:
_query_:"{!join fromIndex=expressionData from=anatomyID to=anatomyID
v='(anatomy:\"brain\")'}"
Say I have an index representing data for gene expression (we work with
genetics), and you query it by anatomy term. So the above would query for all
data that shows gene expression in "brain".
Now I want to get a set of related data for each anatomy term via the join. Is
there any way to get the related data for only anatomy terms in the first 1000
expression data documents (fromIndex)? The reason is because there could be
millions of data documents (fromIndex), and we process them in batches to load
a visualization of the query results.
Doing the join on all the results for each batch I process is becoming a
bottleneck for large sets of data.
Thanks,
-Kevin
The information in this email, including attachments, may be confidential and
is intended solely for the addressee(s). If you believe you received this email
by mistake, please notify the sender by return email as soon as possible.
