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: t.zeppenfe...@ophileon.com
<t.zeppenfe...@ophileon.com>Web: www.ophileon.com
Twitter: tomzeppenfeldt
Skype: tomzeppenfeldt
2014-03-09 16:27 GMT+01:00 Michael Hunger <michael.hun...@neopersistence.com
>:
> 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 <tomzeppenfe...@gmail.com>:
>
> 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 neo4j+unsubscr...@googlegroups.com.
> 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 neo4j+unsubscr...@googlegroups.com.
> 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 neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
