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, <[email protected] <javascript:>> 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 [email protected] <javascript:>.
>> 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 [email protected].
For more options, visit https://groups.google.com/d/optout.
