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.
