Hi all,
I'm working with a database structured like so:
<data>
<element>...</element>
<element>...</element>
<element>...</element>
</data>
There are a total of about 1.5 million <element> nodes in the database.
Each <element> has many child nodes, one of which is uncommon -- it only
appears in 727 <element>s.
I'm writing a query that has a condition on this uncommon field, but the
query takes about 20 seconds to run, whereas another with a condition on a
child node that appears in every <element> only takes about 20 milliseconds
to run.
Based on the Info in the GUI, it does appear that the text index is being
used -- I see 'apply text index for "..."'. Is it expected that the query
time would be this much longer? Is the text index somehow built differently
for nodes that don't appear often in the database?
Thanks in advance,
Matt