Actually your first query was not valid cypher, correct is:
Match (u:User {userid:1})-[f:Friends{status:2}]-(uu:User) RETURN COUNT (uu)
Also I would love to know how you came thinking that the indexes are
not exact lookups?
On Wed, Feb 12, 2014 at 10:43 PM, Reihane Boghrati <[email protected]> wrote:
> Thanks, I really appreciate your help.
>
> Reihane
>
> On Wednesday, February 12, 2014 1:42:04 PM UTC-8, Chris Vest wrote:
>>
>> I think the query planner internally rewrites queries of the first form,
>> to queries of the second form, so they should have pretty much identical
>> performance.
>>
>> --
>> Chris Vest
>> System Engineer, Neo Technology
>> [ skype: mr.chrisvest, twitter: chvest ]
>>
>>
>> On 12 Feb 2014, at 22:35, Reihane Boghrati <[email protected]> wrote:
>>
>> Thank you so much, I'll try that and I'll let you know :)
>> I have one more question, what is the difference between these two
>> queries? Is the first one faster?
>>
>> Match (u:User {userid=1})-[f:Friends{status=2}]-(uu:User) RETURN COUNT
>> (uu)
>> Match (u:User) -[f:Friends]- (uu:User) WHERE u.userid=1 AND f.status =2
>> RETURN COUNT (uu);
>>
>> Best,
>> Reihane
>>
>> On Wednesday, February 12, 2014 12:13:20 PM UTC-8, Chris Vest wrote:
>>>
>>> Hi,
>>>
>>> The schema indexes are 100% accurate. If they are not, then that's a bug
>>> I'd be happy to know about.
>>>
>>> Indexes should not influence correctness. They should only be about
>>> performance.
>>>
>>> --
>>> Chris Vest
>>> System Engineer, Neo Technology
>>> [ skype: mr.chrisvest, twitter: chvest ]
>>>
>>>
>>> On 12 Feb 2014, at 19:54, Reihane Boghrati <[email protected]> wrote:
>>>
>>> Hi,
>>>
>>> I'm writing a client for Neo4j to evaluate that with BG benchmark.
>>> As far as I know, Neo4j is using Lucene for indexing nodes and the Cypher
>>> query for creating index is something like : CREATE INDEX ON :Users(userid)
>>> I believe that Lucene retrieval is not 100% accurate, meaning that if it
>>> doesn't return data, one cannot be sure data is not existed. Is that right?
>>> I browsed different websites but I couldn't find an alternative index
>>> service. I was wondering if anyone is aware of any other accurate index
>>> provider that can be used in Neo4j?
>>>
>>> Best,
>>> Reihane
>>>
>>>
>>> --
>>> 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/groups/opt_out.
>>>
>>>
>>
>> --
>> 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/groups/opt_out.
>>
>>
> --
> 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/groups/opt_out.
--
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/groups/opt_out.
