Thanks a lot for the profiles, I share them with the team.
Yes you're probably right, esp. returning 1k rows every time.
You can also test it with curl or similar, using the transactional cypher
endpoint.
You can also run Neo4jShell.bat from the bin directory to connect to the
running server in a commandline console.
On Mon, Nov 24, 2014 at 3:35 PM, <m...@docware.de> wrote:
> Michael,
>
> I attached the profile console output. So far I tested on the data browser
> tab of the /webadmin. Now I switched to the console tab. But the actions
> take longer there. I think this is a GUI problem when you have run several
> commands. I think the HTML DOM gets longer and longer and thus the browser
> GUI becomes slower. This is not the case on the data browser tab because it
> holds only the latest result.
>
> Best regards
>
> Michael
>
> Am Montag, 24. November 2014 14:39:40 UTC+1 schrieb Michael Hunger:
>>
>> 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+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.
