these ones will be single digit ms in Neo4j 3.0
1.
MATCH (:`label1`)-[:rel1]->() RETURN COUNT(*);
1.
MATCH ()-[:rel1]->(:`label2`) RETURN COUNT(*);
2.
On Thu, Apr 21, 2016 at 12:08 AM, <mvi...@brinqa.com> wrote:
> Michael,
>
> the label in the relation's target, sped up the query a little bit, but
> count looks slow if I do a simple count just by label, it takes too much,
> and I tried to run it several times but I don't see any improvement in
> query execution time, like the query is not cached at all
>
> neo4j-sh (?)$ MATCH (n:`label`) RETURN count(n) as count;
> +---------+
> | count |
> +---------+
> | 1122727 |
> +---------+
> 1 row
> 760 ms
>
>
> El miércoles, 20 de abril de 2016, 10:55:59 (UTC-3), matias...@brinqa.com
> escribió:
>>
>> Thanks Michael.
>> Yeah, double negation because it's part of a more complex logic that has
>> that result, but even removing that condition is slow.
>> We'll try your proposal anyway.
>>
>> On Wednesday, April 20, 2016 at 3:57:47 AM UTC-3, Michael Hunger wrote:
>>>
>>> Double Negation ?
>>> r1 is never null
>>> Add a label to n1
>>> Use a Union
>>> Look at the query plan with profile
>>>
>>> Try this:
>>>
>>>
>>> MATCH (n:`label1`:`label2`) WHERE size( (n)-[:rel1]->() ) = 0
>>> RETURN COUNT(n) AS count;
>>> UNION
>>> MATCH (n:`label1`:`label2`)-[r1:rel1]->(n1:Label3) WHERE n1.`name` IN
>>> ["name1","name2"]
>>> RETURN COUNT(n) AS count;
>>>
>>>
>>> On Wed, Apr 20, 2016 at 12:41 AM, <matias...@brinqa.com> wrote:
>>>
>>>> I'm using Neo4j 2.3.3.
>>>>
>>>> The query is very simple:
>>>>
>>>> neo4j-sh (?)$ MATCH (n:`label1`:`label2`), n-[r1:rel1]->n1 WHERE
>>>> (n1.`name` IN ["name1","name2"] OR NOT(r1 IS NOT NULL)) RETURN COUNT(n) AS
>>>> count;
>>>> +--------+
>>>> | count |
>>>> +--------+
>>>> | 462059 |
>>>> +--------+
>>>> 1 row
>>>> 2894 ms
>>>>
>>>>
>>>> Any ideas on how to improve it?
>>>>
>>>> --
>>>> 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.
