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.
