Hi Peter,
Thanks for your answer.
We did what you mean these 2 last days and we have a "Unknown error" return
from the browser... We are not able to find logs from the server in order
to get any message about the problem ..
Regards,
Le mercredi 7 mai 2014 11:02:22 UTC+2, Peter Neubauer a écrit :
>
> 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]<javascript:>
> > 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] <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.
