Thanks a lot for the update Arnaud Michael
Sent from mobile device Am 09.05.2014 um 03:45 schrieb Arnaud Drazek <[email protected]>: > For those who expect news from this problem, it seems that we have a lot of > duplicate points in our database at the same location. So we have a huge > numbers of cross product results that come back. > We will clean up our data. We realize too that Cypher is not the best and > optimized way to query our geo layer : we will therefor try to develop a > little server plugin able to search for our trips. > > We will certainly keep the community informed ! > > Le mercredi 7 mai 2014 13:33:21 UTC+2, Arnaud Drazek a écrit : >> >> And do you need to access to the server itself ? >> >> Le 7 mai 2014 13:25, "Arnaud Drazek" <[email protected]> a écrit : >>> With great pleasure ! Can I send you the webadmin access via private mail ? >>> >>> Le mercredi 7 mai 2014 13:07:08 UTC+2, Peter Neubauer a écrit : >>>> >>>> Arnaud, >>>> any chance to get some sample of the system or access to it to see what >>>> the problem is? >>>> >>>> /peter >>>> >>>> >>>> G: neubauer.peter >>>> S: peter.neubauer >>>> P: +46 704 106975 >>>> L: http://www.linkedin.com/in/neubauer >>>> T: @peterneubauer >>>> >>>> Open Data - @mapillary >>>> Open Source - @neo4j >>>> Open Future - @coderdojo >>>> >>>> >>>> On Wed, May 7, 2014 at 11:59 AM, Arnaud Drazek <[email protected]> wrote: >>>>> 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 >>>>>> >>>>>> Open Data - @mapillary >>>>>> Open Source - @neo4j >>>>>> Open Future - @coderdojo >>>>>> >>>>>> >>>>>> 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. -- 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.
