Hi Michael, thanks for your apparently not so lazy Sunday feed-back. I'm
aware that it's not production-fähig. We're using this sandbox it hoping to
demo what Neo4j is capable of :S
Tried the suggested query. No luck however. This is what I got (in over 6
secs) . And yes i had an index on :jurt(jurt_id)
neo4j-sh (?)$ schema
Indexes
ON :Person(id) ONLINE (for uniqueness constraint)
ON :Term(id) ONLINE
ON :instantie(id) ONLINE
ON :jurt(jurt_id) ONLINE
ON :rechter(id) ONLINE
Constraints
ON (person:Person) ASSERT person.id IS UNIQUE
neo4j-sh (?)$ export jurtid=J70000
neo4j-sh (?)$ match (j1:jurt)
> where j1.jurt_id = {jurtid}
> with j1
> match (j1)-[:HAS_TERM]->(t)<-[:HAS_TERM]-(j2)
> where j2 <> j1
> return j1.jurt_id,j2.jurt_id, count(t) as commonterms
> order by commonterms desc
> limit 3;
+---------------------------------------+
| j1.jurt_id | j2.jurt_id | commonterms |
+---------------------------------------+
| "J70000" | "J72191" | 68 |
| "J70000" | "J73483" | 67 |
| "J70000" | "J75683" | 66 |
+---------------------------------------+
3 rows
6320 ms
--
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.
