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]<javascript:> > > 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.
