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.
