Hi, I have a question regarding traverser, is there a way how I can optimize my code to use it? Problem is: my use case is a dense graph with a lot of relationships... So most of the time I have one node with thousands of relationships attached.
I have tested my code on the following Graph: 1 root node - 22440 User nodes with unique property: NAME. Since my nodes have unique names, I am using basically the same stop and return evaluators, which simply stop when the property matches the name. Thank you all for your help, and if you want to see my results, please read further below. best regards, Marius ---- Performance of getUser by NAME: User: 7787382767bbd488f70409f8f08b18bd which is the first user imported, oldest entry in the DB. User: 7e642b44fd61dc38ad61d82a89d0162c is somewhere in the middle of the import User: 7cdb0c1f76896cc139774fc2b7c40d28 my last one or the joungest user in the db. ++++ Just using Lucene index to fetch user by name: Time: 0.014s (14ms) for 7787382767bbd488f70409f8f08b18bd - old Time: 0.0050s (5ms) for 7e642b44fd61dc38ad61d82a89d0162c - average Time: 0.0040s (4ms) for 7cdb0c1f76896cc139774fc2b7c40d28 - young ++++ Just the traverser: Time: 3.758s (3758ms) for 7787382767bbd488f70409f8f08b18bd - old Time: 0.541s (541ms) for 7e642b44fd61dc38ad61d82a89d0162c - average Time: 0.038s (38ms) for 7cdb0c1f76896cc139774fc2b7c40d28 - young ++++ Comparing both against each other: Time: 0.064s (64ms) for 7787382767bbd488f70409f8f08b18bd - old on index Time: 3.815s (3815ms) for 7787382767bbd488f70409f8f08b18bd - old on traverser Time: 0.018s (18ms) for 7e642b44fd61dc38ad61d82a89d0162c - average on index Time: 0.556s (556ms) for 7e642b44fd61dc38ad61d82a89d0162c Time: 0.014s (14ms) for 7cdb0c1f76896cc139774fc2b7c40d28 - young Time: 0.034s (34ms) for 7cdb0c1f76896cc139774fc2b7c40d28 +++ Just changed the order of queries to check Time: 0.0040s (4ms) for 7e642b44fd61dc38ad61d82a89d0162c - average on index Time :3.271s (3271ms) for 7e642b44fd61dc38ad61d82a89d0162c - average on traverser Time: 0.0010s (1ms) for 7cdb0c1f76896cc139774fc2b7c40d28 - young Time: 0.042s (42ms) for 7cdb0c1f76896cc139774fc2b7c40d28 Time: 0.0010s (1ms) for 7787382767bbd488f70409f8f08b18bd - old Time: 0.856s (856ms) for 7787382767bbd488f70409f8f08b18bd _______________________________________________ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
