Could you do me one more favor and prefix your two queries (normal and with
cypher 2.1.experimental) with "profile" and share the profile output?
That would be helpful in identifying other optimization options.
Cheers, Michael
On Mon, Nov 24, 2014 at 12:03 PM, <m...@docware.de> wrote:
> Thanks Michael,
>
> The conf/neo4j.properties did not make a big difference. It reduced the
> query time from 1,8 to 1.6 s (repeated case) for the new query planner.
> And yes, the stacktrace is gone.
>
> asusme that :Mat is more selective, so can you try using:
>>
>> MATCH (assy:Assy {k_ebene: 'MODEL'})-[:HAS*..]->(mat:Mat {m_matnr:
>> "A4420380071"})
>> USING INDEX mat:Mat(m_matnr)
>> RETURN count(*)
>>
>> no difference
> -> I meant in timing not in count :)
>
> I meant too :-)
>
> > MATCH (assy:Assy {k_ebene: 'MODEL'}) return count(*); -> 1311
> > MATCH (mat:Mat {m_matnr: "A4420380071"}) return count(*) ; -> 1
>
> Thank you again also for your comment re. Java traversal
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
