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 <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 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 <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.
