[Neo4j] TLS over HTTPS working; BOLT fails

2016-06-21 Thread Jesse Hemingway
I'm using a CA-issued SSL cert to secure both HTTPS and BOLT from a single Neo4j instance. Connections over HTTPS are working just fine, and the browser likes the cert. However, when connecting via the Bolt driver (1.0.2 for Node.js), I'm getting this error: *You are using

Re: [Neo4j] Understanding effect of LIMIT on planning

2016-03-05 Thread Jesse Hemingway
And specifying those indices explicitly cut the db hits in half! I had read your Performance Tuning article and had put that little nugget on the back burner, not realizing how critical it could be! On Saturday, March 5, 2016 at 4:13:23 PM UTC-6, Jesse Hemingway wrote: > > Wow, there are

Re: [Neo4j] Understanding effect of LIMIT on planning

2016-03-05 Thread Jesse Hemingway
})-[:REFERS_TO]->(: > Post)-[:PREVIOUS*0..100]->(p) > WITH p, [c in categories WHERE (p)-[:MEMBER_OF]->(c) | c.uuid] as > categories where size(categories) > 0 > RETURN p, categories > limit 20 > > > > On Sat, Mar 5, 2016 at 6:17 PM, Jesse Hemingway <jiro...@gma

Re: [Neo4j] Re: Clearing nodes

2016-03-06 Thread Jesse Hemingway
; > Von meinem iPhone gesendet > > Am 06.03.2016 um 00:47 schrieb Jesse Hemingway <jiro...@gmail.com > >: > > Ok, that certainly works. That's a bit boggling -- I have quite a few > indexes and constraints, if that could have any effect. I also use the > TimeTree mod

Re: [Neo4j] Understanding effect of LIMIT on planning

2016-03-05 Thread Jesse Hemingway
an try is to just get the longest path and then take > all the nodes of the path. > > PROFILE MATCH (r:Reference {id: "latest"})-->(first:Post) > MATCH path = (first)-[rels:PREVIOUS*0..50]->(p) > WITH path > ORDER BY size(rels) DESC LIMIT 1 > UNWIND nodes(path) as

Re: [Neo4j] Re: Clearing nodes

2016-03-05 Thread Jesse Hemingway
d, etc. On Saturday, March 5, 2016 at 7:18:56 AM UTC-6, Michael Hunger wrote: > > Unused recoreds are reclaimed after restart, so if you restart after > cleaning out then it will. > But you can also just delete the db-directory. > > On Fri, Mar 4, 2016 at 10:52 PM, Jesse Hemi

[Neo4j] Understanding effect of LIMIT on planning

2016-03-05 Thread Jesse Hemingway
I'm pretty new to neo4j, and I'm working on optimizing my queries. For my example, let's say we have a lot of 'Post' nodes that can grow in an unbounded fashion. I'm using a linked-list to be able to scan back through recent posts without consulting every node. This works, but my question has