I just read the Michael post about full context..
So :
- neo4j version : 2.0.2
- OS : Ubuntu server 12.04.3 LTS
- java -version : build 1.7.0_45-b18
We are using everyman php library but the result I've give you are from the
webadmin.
I will give you our graph structure if you need.
We note that java will take about 100% of CPU when we ask for result from
neo...
Thanks for the support !
Arnaud
Le mercredi 7 mai 2014 12:24:06 UTC+2, Arnaud Drazek a écrit :
>
> 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.
