Mina, as I just came across a similar scenario, I created a gist on your problem (with relationships in both directions here) to illustrate the problem. I think this is real, we are looking at it, see http://gist.neo4j.org/?8331742
Thanks for lifting this! /peter G: neubauer.peter S: peter.neubauer P: +46 704 106975 L: http://www.linkedin.com/in/neubauer T: @peterneubauer Neo4j 2.0.0 - (graphs)-[:FOR]->(everyone)<http://blog.neo4j.org/2013/12/neo4j-20-ga-graphs-for-everyone.html> Do something useful - Teach your kids 1 hour code! <http://code.org/learn> On Wed, Jan 8, 2014 at 10:22 PM, Michael Hunger < [email protected]> wrote: > And subsequent runs? > > How big is your db? What is your memory config ? > > Feel free to share your graph.db/messages.log which contains all the info. > > Michael > > Am 08.01.2014 um 20:07 schrieb mina sh <[email protected]>: > > it takes 619447 ms . i don't know this is normal or not. > > On Wednesday, January 8, 2014 10:05:08 PM UTC+3:30, Michael Hunger wrote: >> >> How long does it take? >> And is this the first run or a subsequent run? >> >> I don't thing you get faster by starting at the infected relationships. >> At least not with cypher. >> >> START x=node:person("infTime:*") >> >> MATCH x-[r:infected]->() >> >> RETURN x, count(r) as fof >> >> order by fof desc >> >> limit 1 >> >> >> If you already have a sensible threshold, like 10 or 100 you might use >> that too. >> >> START x=node:person("infTime:*") >> >> MATCH x-[r:infected]->() >> >> WITH x, count(r) as fof >> >> WHERE fof > 10 >> >> >> return fof, x >> >> order by fof desc >> limit 1 >> >> Am 08.01.2014 um 19:19 schrieb mina sh <[email protected]>: >> >> thank you very much. >> I have another question, in this case that I have a infected >> relationship, can I get the query that return the node that has the most >> outgoing infected link (this is the node that infect others the most) >> I wrote a query but it takes a lot to return the answer.this is becuase i >> start from all node "(infTime:*)". I want to know is there a way to get >> query by starting from the "infected" relationship and get that query? >> (infTime is a propety that for example infTime=10 shows the node get >> infected in the time 10) >> >> START x=node:person("infTime:*") >> >> MATCH x-[r:infected]->() >> >> WITH x, count(r) as fof >> >> return fof, x >> >> order by fof desc >> limit 1 >> >> On Monday, January 6, 2014 3:23:12 PM UTC+3:30, Michael Hunger wrote: >>> >>> You would model those infected-by information relationships between the >>> nodes, not as property containing a number. >>> >>> Then you can use variable length paths to do long and also circular >>> matches in the graph. >>> >>> MATCH p=(n:Person {name:"Mina"})-[:INFECTED_BY*]->(m) >>> RETURN path,m >>> >>> HTH >>> >>> Michael >>> >>> Am 06.01.2014 um 09:36 schrieb mina sh <[email protected]>: >>> >>> i want to get recursive query in neo4j with cypher. >>> in dataset ,nodes has property "whom" that shows the node get infected >>> by whom >>> (for exmaple node[1] is infected by node[10].-> node(1).whom= 10 ) >>> i want to search the graph recurively from the node[1] to node [10] and >>> recursively so on to reach to the first node that has a whom=0 . >>> >>> -- >>> 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. > -- 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.
