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, <[email protected] <javascript:>> 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, <[email protected]> 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].
>>>> 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] <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.
profile MATCH (assy:Assy {k_ebene: 'MODEL'})-[:HAS*..]->(mat:Mat {m_matnr:
"A4420380071"}) RETURN assy.k_vari order by assy.k_vari;
==> 27776 rows
==>
==> ColumnFilter
==> |
==> +Sort
==> |
==> +Extract
==> |
==> +Filter
==> |
==> +TraversalMatcher
==>
==>
+------------------+--------+---------+-------------+---------------------------------------------------------------------------+
==> | Operator | Rows | DbHits | Identifiers |
Other |
==>
+------------------+--------+---------+-------------+---------------------------------------------------------------------------+
==> | ColumnFilter | 27776 | 0 | |
keep columns assy.k_vari |
==> | Sort | 27776 | 0 | |
Cached(assy.k_vari of type Any) |
==> | Extract | 27776 | 55552 | |
assy.k_vari |
==> | Filter | 27776 | 1530816 | |
(Property(assy,k_ebene(1)) == { AUTOSTRING0} AND hasLabel(assy:Assy(0))) |
==> | TraversalMatcher | 510272 | 1273795 | |
assy, UNNAMED36, assy |
==>
+------------------+--------+---------+-------------+---------------------------------------------------------------------------+
==>
==> Total database accesses: 2860163
profile cypher 2.1.experimental MATCH (assy:Assy {k_ebene:
'MODEL'})-[:HAS*..]->(mat:Mat {m_matnr: "A4420380071"}) RETURN assy.k_vari
order by assy.k_vari;
==> 27776 rows
==>
==> Projection(0)
==> |
==> +Sort
==> |
==> +Projection(1)
==> |
==> +Filter
==> |
==> +Var length expand
==> |
==> +NodeIndexSeek
==>
==>
+-------------------+--------+---------+------------------------+-----------------------------------------------------------------------------------------------------------------------------+
==> | Operator | Rows | DbHits | Identifiers |
Other |
==>
+-------------------+--------+---------+------------------------+-----------------------------------------------------------------------------------------------------------------------------+
==> | Projection(0) | 27776 | 55552 | |
assy.k_vari |
==> | Sort | 27776 | 0 | |
FRESHID116 |
==> | Projection(1) | 27776 | 55552 | |
FRESHID116, mat, UNNAMED36, assy |
==> | Filter | 27776 | 2041088 | |
(hasLabel(assy:Assy) AND any(-_-INNER-_- in Collection(List({ AUTOSTRING0}))
where Property(assy,k_ebene) == -_-INNER-_-)) |
==> | Var length expand | 510272 | 1020545 | mat, assy, UNNAMED36 |
|
==> | NodeIndexSeek | 1 | 2 | mat |
:Mat(m_matnr) |
==>
+-------------------+--------+---------+------------------------+-----------------------------------------------------------------------------------------------------------------------------+
==>
==> Total database accesses: 3172739
profile MATCH (assy:Assy { k_ebene: 'MODEL' })-[:HAS*..]->(mat:Mat { m_matnr:
"A4420380071" })
WITH DISTINCT assy.k_vari AS k_vari
RETURN k_vari
ORDER BY k_vari
LIMIT 1000;
==> 619 rows
==>
==> Top
==> |
==> +Distinct
==> |
==> +Extract
==> |
==> +Filter
==> |
==> +TraversalMatcher
==>
==>
+------------------+--------+---------+-------------+---------------------------------------------------------------------------+
==> | Operator | Rows | DbHits | Identifiers |
Other |
==>
+------------------+--------+---------+-------------+---------------------------------------------------------------------------+
==> | Top | 619 | 0 | |
{ AUTOINT2}; k_vari |
==> | Distinct | 619 | 0 | |
|
==> | Extract | 27776 | 55552 | |
k_vari |
==> | Filter | 27776 | 1530816 | |
(Property(assy,k_ebene(1)) == { AUTOSTRING0} AND hasLabel(assy:Assy(0))) |
==> | TraversalMatcher | 510272 | 1273795 | |
assy, UNNAMED38, assy |
==>
+------------------+--------+---------+-------------+---------------------------------------------------------------------------+
==>
==> Total database accesses: 2860163
profile cypher 2.1.experimental MATCH (assy:Assy { k_ebene: 'MODEL'
})-[:HAS*..]->(mat:Mat { m_matnr: "A4420380071" })
WITH DISTINCT assy.k_vari AS k_vari
RETURN k_vari
ORDER BY k_vari
LIMIT 1000;
==> 619 rows
==>
==> Top
==> |
==> +Apply
==> |
==> +EagerAggregation
==> | |
==> | +Projection
==> | |
==> | +Filter
==> | |
==> | +Var length expand
==> | |
==> | +NodeIndexSeek
==> |
==> +Null
==>
==>
+-------------------+--------+---------+------------------------+-----------------------------------------------------------------------------------------------------------------------------+
==> | Operator | Rows | DbHits | Identifiers |
Other |
==>
+-------------------+--------+---------+------------------------+-----------------------------------------------------------------------------------------------------------------------------+
==> | Top | 619 | 0 | |
{ AUTOINT2}; k_vari |
==> | Apply | 619 | 0 | |
|
==> | EagerAggregation | 619 | 0 | |
k_vari |
==> | Projection | 27776 | 55552 | |
mat, UNNAMED38, assy, k_vari |
==> | Filter | 27776 | 2041088 | |
(hasLabel(assy:Assy) AND any(-_-INNER-_- in Collection(List({ AUTOSTRING0}))
where Property(assy,k_ebene) == -_-INNER-_-)) |
==> | Var length expand | 510272 | 1020545 | mat, assy, UNNAMED38 |
|
==> | NodeIndexSeek | 1 | 2 | mat |
:Mat(m_matnr) |
==> | Null | ? | ? | |
|
==>
+-------------------+--------+---------+------------------------+-----------------------------------------------------------------------------------------------------------------------------+
==>
==> Total database accesses: ?
--
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.
