Another information : if I remove de Trip node, neo4j give me an answer in
about 5000ms..
start departure = node:`geo`('withinDistance:[47.4667,-0.55, 10.0]'),
> arrival = node:`geo`('withinDistance:[47.2173,-1.5534, 10.0]')
> return count(*)
>
>
Le mercredi 7 mai 2014 12:05:12 UTC+2, Arnaud Drazek a écrit :
>
> A count whithout geoindex lookup will give us a response in about 200ms
> start t = node:`Ecolutis\Room\Travel\Entity\Trip`('id:*') return count(*)
>
> Le mercredi 7 mai 2014 11:59:55 UTC+2, Arnaud Drazek a écrit :
>>
>> 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]> 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.
