First run or subsequent one? And do you run this shell against server or standalone with memory config changed?
I mean it has to pull through 500.000 paths, group them by j2 and sort them into the size 3 top-window. But still it shouldn't take that long. Still investingating, sorry. Am 10.03.2014 um 13:40 schrieb Tom Zeppenfeldt <[email protected]>: > no problem .. I figured out that I had to use the terms and the 1.2M went in > under 2 minutes :) > > now back to our query > > match (j1:jurt)-[:HAS_TERM]->(t)<-[:HAS_TERM]-(j2) > where j1.jurt_id = 'J70000' AND j2 <> j1 > RETURN j2,count(*) as commonterms > order by commonterms desc > limit 3; > > still over 4 secs > neo4j-sh (?)$ match (j1:jurt)-[:HAS_TERM]->(t)<-[:HAS_TERM]-(j2) > > > where j1.jurt_id = 'J70000' AND j2 <> j1 > > > RETURN j2.jurt_id,count(*) as commonterms > > > order by commonterms desc > > > limit 3; > > +--------------------------+ > > | j2.jurt_id | commonterms | > > +--------------------------+ > > | "J72191" | 68 | > > | "J73483" | 67 | > > | "J72923" | 66 | > > +--------------------------+ > > 3 rows > > 4358 ms > > neo4j-sh (?)$ > > > > I also tried to follow this > http://stackoverflow.com/questions/18192774/how-to-change-the-memory-config-for-the-neo4j-shell-command-tool-of-cypher-batch > but not sure whether it has any effect. > However, you talking about editing bin/neo4j-shell, makes me doubt whether > I'm doing the right thing. sorry, I'm on a steep learning curve here :) . > Are you meaning to edit this section ? > > exec "$JAVACMD" $JAVA_OPTS \ > > $EXTRA_JVM_ARGUMENTS \ > > -classpath "$CLASSPATH" \ > > -Dapp.name="neo4j-shell" \ > > -Dapp.pid="$$" \ > > -Dapp.repo="$REPO" \ > > -Dbasedir="$BASEDIR" \ > > -Dfile.encoding=UTF-8 \ > > org.neo4j.shell.StartClient \ > > "$@" > > > > > > > -- > 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]. For more options, visit https://groups.google.com/d/optout.
