Re: [Neo4j] Big Traverser perfomance : are '23 rels per milliseconds' good ?
Hi Michael, I tried to lower the values by 30% = same and then by 50% = same again. (MapMemException) Here is the message.log http://pastebin.com/bvhhZfjZ My neo4j.properties looks like that : neostore.nodestore.db.mapped_memory=100M neostore.propertystore.db.arrays.mapped_memory=50M neostore.propertystore.db.index.keys.mapped_memory=1M neostore.propertystore.db.index.mapped_memory=1M neostore.propertystore.db.mapped_memory=500M neostore.propertystore.db.strings.mapped_memory=200M neostore.relationshipstore.db.mapped_memory=400M Any idea ? -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Big-Traverser-perfomance-are-23-rels-per-milliseconds-good-tp3400711p3409259.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
[Neo4j] Big Traverser perfomance : are '23 rels per milliseconds' good ?
Hi all, I am using neo4j 1.5 java embedded. My traverser is a main java program http://pastebin.com/1ynVESbc which takes a db path as input. What it does is pretty basic : it follows my graph (which is a tree) and stores the ending leaves in a file. However it is quite big : I goes through 800.000 relationships and outputs 590.000 nodes in a txt file (11 MB) The global properties of my DB are the following : 962.008 nodes, 5.697.359 properties, 4.301.267 relationships, 2 relationship types. I do have the best results with the following JVM parameters : -server -Xmx2500m -d32 -XX:+UseNUMA JVM is 32 bits SUN JVM 1.6.0_24 CPU is single core Intel(R) Xeon(R) CPU X5660 @ 2.80GHz OS: RHEL 5.5. As you can see in my code I did warm up the cache by making 2 traversers. First pass : 44 seconds 2nd pass : 34.5 seconds which make 23 relationships traversed per milliseconds. What do you think of that figures ? Do you see obvious things I should do to improve the speed of the traversal ? Thanks, Guillaume -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Big-Traverser-perfomance-are-23-rels-per-milliseconds-good-tp3400711p3400711.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] Big Traverser perfomance : are '23 rels per milliseconds' good ?
Hi, Here are the answers I can give you quickly: How much memory does your machine have? 5066 MB (from free -m) What kind of disk is in there? I do not know, the machine is a VM provided by another department of my company. What I can tell you is that on my i5 laptop the same was taking 6-8 minutes. Have you looked at the memory config for the neo4j db? No I did only change the head size. What kind of scheduler do you use (please try deadline or as)? it seems to be as. Can you please share the config and JVM info that is output at the head of graphdb/messages.log ? see here http://pastebin.com/0geHdbNu -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Big-Traverser-perfomance-are-23-rels-per-milliseconds-good-tp3400711p3400925.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] Neo4j server - Gremlin plugin - line break in script
Hi all, Hi event with \n, I am not able to send this script {script:g.v(1);g.v(2)} in 2 lines. BTW I am still using 1.4. Stack trace is here http://pastebin.com/WYVJPy3K http://pastebin.com/WYVJPy3K It says Unrecognized character escape (CTRL-CHAR, code 10) -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Neo4j-server-Gremlin-plugin-line-break-in-script-tp3191845p3274688.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] Neo4j server - Gremlin plugin - line break in script
Hi, I am using a simple rest client in chrome to try to send my gremlin script (working without a line break) https://chrome.google.com/webstore/detail/fhjcajmcbmldlhcimfajhfbgofnpcjmb -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Neo4j-server-Gremlin-plugin-line-break-in-script-tp3191845p3275191.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
[Neo4j] Neo4j server - Gremlin plugin - line break in script
Hi, I am using neo4j server 1.4. I want to send a gremin script (which is ok with script with one line). I am wondering if I can send script with line break in it. I currently have /message: Illegal unquoted character ((CTRL-CHAR, code 10)): has to be escaped using backslash to be included in string value at [Source: java.io.StringReader@fde4e6; line: 1, column: 21], exception: org.neo4j.server.rest.repr.BadInputException: Illegal unquoted character ((CTRL-CHAR, code 10)): has to be escaped using backslash to be included in string value at [Source: java.io.StringReader@fde4e6; line: 1, column: 21], stacktrace: [(36)/ -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Neo4j-server-Gremlin-plugin-line-break-in-script-tp3191845p3191845.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] Neo4j server - Gremlin plugin - line break in script
Hi Peter, Thanks for your answer. I knew that it was possible to put semi colons for line break ;-) To be more precise, I have the following script that was given kindly given by Marko on another thread. m = [:] g.idx('id')[[object_type:'A']].transform{ if(it.out('USES'){it.object_type.equals('B')}.count() 1) count = 1 else count 1 }.groupCount(m) -1 m I know it is possible to do the same following in one line (see below) however I would like, for more readability to be able to submit it to the REST gremlin plugin with multiple lines. m = [:] ;g.idx('id')[[object_type:'A']].transform{if(it.out('USES'){it.object_type.equals('B')}.count() 1) count = 1 else count 1}.groupCount(m) -1 ; m Guillaume in holiday tonight ;-) -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Neo4j-server-Gremlin-plugin-line-break-in-script-tp3191845p3192325.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] Cypher request with where clause on relations count
Request is working like a charm and is fast (around 6 objects are checked in my 2M node 6M rel DB). I have to check the result with the corresponding RDBMS KPI. Thanks again ! I definitively have to take more time to learn Gremlin ! -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Neo4j-Cypher-request-with-where-clause-on-relations-count-tp3172481p3187757.html Sent from the Neo4J Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] Cypher request with where clause on relations count
Neo4jists, Was my question dumb or was it really not clear ? Cheers -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Neo4j-Cypher-request-with-where-clause-on-relations-count-tp3172481p3185907.html Sent from the Neo4J Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] Cypher request with where clause on relations count
@Michael I am glad that this feature will be added in 1.5 and I already did the java code but I wanted to do it with server. @Marko thanks. I just tried to do it with Gremlin but I have not your knowledge of gremlin. I will try to do that. -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Neo4j-Cypher-request-with-where-clause-on-relations-count-tp3172481p3186529.html Sent from the Neo4J Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] Cypher request with where clause on relations count
@Marko I am using neo4j 1.4 server so I guess I am running gremlin 1.1. It would be cool if you can send me the compatible query when you have time. -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Neo4j-Cypher-request-with-where-clause-on-relations-count-tp3172481p3186571.html Sent from the Neo4J Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user