Ouch Share via dropbox
You can share the 2.1 store with me or the loadcsv script with your csv files Thanks for all the great feedback btw Can you send me your postal address and t-shirt size? Thx Sent from mobile device Am 09.03.2014 um 19:08 schrieb Tom Zeppenfeldt <[email protected]>: > Ok Michael, > > - Just a question that may sound stupid : What's the best way to share > things privately over here ? Not seeing any clear option to do so. > - I'll try to setup a server with 2.0.1 and try to use the > shell-import-tools. FYI : uploading the 1.2M rels uring LOAD CSV took over 24 > hrs ... hope your shell-import-tools work faster .. > > 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: [email protected] > Web: www.ophileon.com > Twitter: tomzeppenfeldt > Skype: tomzeppenfeldt > > > 2014-03-09 16:27 GMT+01:00 Michael Hunger <[email protected]>: >> 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. > > -- > 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.
