no problem Michael. It takes long for each query. changing memconfig didn't make a lot of difference . Also talking with the structr.org guys about it..
Best, Tom Met vriendelijke groet / With kind regards Ir. T. Zeppenfeldt van der Waalsstraat 30 6706 JR Wageningen The Netherlands Mobile: +31 6 23 28 78 06 Phone: +31 3 17 84 22 17 E-mail: t.zeppenfe...@ophileon.com <t.zeppenfe...@ophileon.com>Web: www.ophileon.com Twitter: tomzeppenfeldt Skype: tomzeppenfeldt 2014-03-14 15:15 GMT+01:00 Michael Hunger <michael.hun...@neopersistence.com >: > 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 <tomzeppenfe...@gmail.com>: > > 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-batchbut > 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 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. > -- 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.