Hello. I have created what I believe is a not-terribly-complex Neo database. If you want to cut to the chase, just scroll down to the section called "*The Problem*"
Here is the structure: *Nodes* (:Document) ~75k (:Country) ~300 (:Person) ~8k *Relationships* -[:MENTIONS]-> ~300k *System Information* 16 Cores 480gb HD 48GB RAM Ubuntu Server 14.04 LTS Neo4j Version 2.1.5 *Config* I've adjusted for the config is the min and max heap size (disabled by default) Min: 2048 Max: 4096 I set the max open files to 60000 from the default 1024 for my system (Linux users know what I'm talking about) I set a max query time of two minutes via the `org.neo4j.server.webserver.limit.executiontimeout` param, though I only did this recently because many queries were taking longer than two minutes. Prior to this, certain queries which I would guess should be fast would never finish (see below) I have also indexed a parameter on all nodes called `source_id`, which is the `id` value for these things in the database from which I imported them. *Weird Observatons* Before I altered the max and min heap sizes in the config file, `htop` was showing me some (alarming??) stats -- VIRT was 17.5GB for the server process. Now, with the new settings, it's at a much lower 10100M, but I still don't understand why. *The Problem* Here's a simple query that never returns. I've waited as long as 5 minutes and still nothing: MATCH(d:Document)-[*2]-(something) WHERE d.source_id='SOMEIDHERE' RETURN d,something; Based on some of the queries I've seen other people talk about, with variable relations in the dozens, and for datasets that have millions of nodes using laptop hardware, something seems very wrong to me here. I've read all of the articles I could find on configurations and ways to improve performance. Any ideas? -- 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.
