Hi Michael,
Thanks for your reply. Basically you suggest not to overspecify the
queries, by leaving out the labels or identifiers when not necessary. And
I learned my lesson with regard to using snapshots :)
BTW : Assuming that you are using the db that I shared with you and
converted it to a 2.0.1. version, I appreciated the increased speed, but
does it also explain why the returned counts are different ?
If you have converted the db, could you share the datastore (the 2.0.1.
one) back to me ?
Thanks a lot !
Best, Tom
On Monday, 10 March 2014 07:11:00 UTC+1, Michael Hunger wrote:
>
> Hi Tom,
>
> with 2.0.1 the query time went down to 1.6 seconds.
> It still has to pull through and aggregate 500.000 rels but should
> actually be faster doing this.
>
> match (j1:jurt)-[:HAS_TERM]->(t)<-[:HAS_TERM]-(j2)
> where j1.jurt_id = 'J70000' AND j2 <> j1
> RETURN j2,count(*) as commonterms
> order by commonterms desc
> limit 3;
>
> +---------------------------------------------+
> | j2 | commonterms |
> +---------------------------------------------+
> | Node[19946]{jurt_id:"J72191"} | 68 |
> | Node[20977]{jurt_id:"J73483"} | 67 |
> | Node[21658]{jurt_id:"J74261"} | 64 |
> +---------------------------------------------+
> 3 rows
> 1614 ms
>
> Cheers,
>
> Michael
>
> ----
> (michael
> <http://twitter.com/mesirii>}-[:SUPPORTS]->(*YOU*)-[:USE]->(Neo4j<http://neo4j.org>
> )
> Learn Online <http://neo4j.org/learn/online_course>,
> Offline<http://www.neo4j.org/events> or
> Read a Book <http://graphdatabases.com> (in Deutsch<http://bit.ly/das-buch>
> )
> We're trading T-shirts for cool GraphGist Models <http://bit.ly/graphgist>
>
>
>
>
>
> Am 09.03.2014 um 20:00 schrieb Michael Hunger <
> [email protected] <javascript:>>:
>
> 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]<javascript:>
> >:
>
> 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] <javascript:>
> <javascript:>Web: www.ophileon.com
> Twitter: tomzeppenfeldt
> Skype: tomzeppenfeldt
>
>
> 2014-03-09 16:27 GMT+01:00 Michael Hunger
> <[email protected]<javascript:>
> >:
>
>> 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]<javascript:>
>> >:
>>
>> 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] <javascript:>.
>> 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] <javascript:>.
>> 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] <javascript:>.
> 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.
