Where in the neo4j-shell -> or "Console" tab of the /webadmin?
That's where you should measure anyway.
Michael
On Mon, Nov 24, 2014 at 2:25 PM, <m...@docware.de> wrote:
> Hello Michael,
>
> every query that I prefix with profile like the one below gives the error
> below:
>
> profile MATCH (assy:Assy {k_ebene: 'MODEL'})-[:HAS*..]->(mat:Mat {m_matnr:
> "A4420380071"})
> RETURN assy.k_vari order by assy.k_vari limit 100
>
> Invalid input 'p': expected (line 1, column 1)
> "profile MATCH (assy:Assy {k_ebene: 'MODEL'})-[:HAS*..]->(mat:Mat {m_matnr:
> "A4420380071"})"
> ^
>
>
> What am I doing wrong?
>
> Am Montag, 24. November 2014 12:06:40 UTC+1 schrieb Michael Hunger:
>>
>> 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+un...@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.
>
--
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.
