Could you send me the profike output from the shell? Easier to read on mobile and also share the db with me privately
Can you also try the query in 2.0.1? You can import the data using my shell-import-tools Or just generate textual cypher statements from load-csv Sent from mobile device Am 09.03.2014 um 16:11 schrieb Tom Zeppenfeldt <[email protected]>: > query is executed as follows, in which I spot: > > "_rows" : 478380, > "_db_hits" : 956760, > > which is actually higher (= worse ??) than the original .. > > { > "columns" : [ "j1.jurt_id", "j2.jurt_id", "commonterms" ], > "data" : [ [ "J70000", "J72191", 68 ], [ "J70000", "J73483", 67 ], [ > "J70000", "J75683", 66 ] ], > "plan" : { > "args" : { > "returnItemNames" : [ "j1.jurt_id", "j2.jurt_id", "commonterms" ], > "_rows" : 3, > "_db_hits" : 0, > "symKeys" : [ "j1.jurt_id", "j2.jurt_id", " > INTERNAL_AGGREGATEb6207bc9-3236-4e8f-ad48-51d2d73e3372" ] > }, > "dbHits" : 0, > "name" : "ColumnFilter", > "children" : [ { > "args" : { > "limit" : "Literal(3)", > "orderBy" : [ "SortItem(Cached( > INTERNAL_AGGREGATEb6207bc9-3236-4e8f-ad48-51d2d73e3372 of type > Integer),false)" ], > "_rows" : 3, > "_db_hits" : 0 > }, > "dbHits" : 0, > "name" : "Top", > "children" : [ { > "args" : { > "keys" : [ "Cached(j1.jurt_id of type Any)", "Cached(j2.jurt_id of > type Any)" ], > "_rows" : 9992, > "aggregates" : [ "( > INTERNAL_AGGREGATEb6207bc9-3236-4e8f-ad48-51d2d73e3372,Count(t))" ], > "_db_hits" : 0 > }, > "dbHits" : 0, > "name" : "EagerAggregation", > "children" : [ { > "args" : { > "_rows" : 478380, > "_db_hits" : 956760, > "exprKeys" : [ "j1.jurt_id", "j2.jurt_id" ], > "symKeys" : [ "j1", "t", " UNNAMED79", "j2", " UNNAMED62" ] > }, > "dbHits" : 956760, > "name" : "Extract", > "children" : [ { > "args" : { > "_rows" : 478380, > "_db_hits" : 0, > "pred" : "NOT(j2 == j1)" > }, > "dbHits" : 0, > "name" : "Filter", > "children" : [ { > "args" : { > "g" : "(j1)-[' UNNAMED62']-(t),(j2)-[' UNNAMED79']-(t)", > "_rows" : 478380, > "_db_hits" : 0 > }, > "dbHits" : 0, > "name" : "SimplePatternMatcher", > "children" : [ { > "args" : { > "identifiers" : [ "j1" ], > "query" : "{jurtid}", > "producer" : "SchemaIndex", > "_rows" : 1, > "property" : "jurt_id", > "label" : "jurt", > "_db_hits" : 0, > "identifier" : "j1" > }, > "dbHits" : 0, > "name" : "SchemaIndex", > "children" : [ ], > "rows" : 1 > } ], > "rows" : 478380 > } ], > "rows" : 478380 > } ], > "rows" : 478380 > } ], > "rows" : 9992 > } ], > "rows" : 3 > } ], > "rows" : 3 > } > } > -- > 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.
