Arnaud,
to start with, could you try to check where the time is spent - in the geo
index lookup or in the actual Cypher match?
What timing does
start t = node:`Ecolutis\Room\Travel\Entity\Trip`('id:*'), departure =
node:`geo`('withinDistance:[47.4667,-0.55, 10.0]'), arrival =
node:`geo`('withinDistance:[47.2173,-1.5534, 10.0]')
return count(*)
give you?
G: neubauer.peter
S: peter.neubauer
P: +46 704 106975
L: http://www.linkedin.com/in/neubauer
T: @peterneubauer <http://twitter.com/peterneubauer>
Open Data - @mapillary <http://mapillary.com/>
Open Source - @neo4j <http://neo4j.org/>
Open Future - @coderdojo <http://malmo.coderdojo.se/>
On Wed, May 7, 2014 at 10:57 AM, Arnaud Drazek <[email protected]> wrote:
> Hi all,
>
> We are a little company working on a carsharing project. We are using
> neo4j for our travel model but when we import our 12.000 trips from our old
> platform, we are experiencing performance issues.
>
> Our model is as follow :
>
> Trip
> Trip HAS TripPoint
> TripPoint HAS Waypoint
>
> We have actually about 12.000 Trip nodes in neo4j and 100.000 nodes at all.
>
> The query is as follow :
> start t = node:`Ecolutis\Room\Travel\Entity\Trip`('id:*'), departure =
> node:`geo`('withinDistance:[47.4667,-0.55, 10.0]'), arrival =
> node:`geo`('withinDistance:[47.2173,-1.5534, 10.0]')
> match (t)-[:HAS_TRIP_POINT]->(tp), (tp)-[:HAS_WAYPOINT]->(departure),
> (tp)-[:HAS_WAYPOINT*1..]->(arrival)
> where (not((arrival)-[:HAS_WAYPOINT]->())) AND (has(t.status) AND t.status
> = 1) AND ((NOT HAS(t.preferences)) OR NONE (pref IN [2] WHERE pref IN
> t.preferences))
> return count(t)
>
> It tooks 6883 ms to return a single row with a count of 4 ...
>
> We are sure that we will have much better performances but although we
> have been around the web, we do not understand what is not well configured.
>
> Thanks for your answers and sorry for my frenchy english ...
>
> Regards,
>
> Arnaud
>
> --
> 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.
