[Neo4j] Neo4j sponsoring the global day of code retreat

2011-11-23 Thread Michael Hunger
I'm happy to announce that Neo Technology sponsors the Global Day of Code Retreat as a Continent Sponsor. Quote from Corey Haines (http://coderetreat.org) Global Day of Coderetreat is a world-wide event celebrating passion and software craftsmanship. Over 2000 passionate software developers

Re: [Neo4j] Neo4j sponsoring the global day of code retreat

2011-11-23 Thread Peter Neubauer
Cool, just looking up Copenhagen ... http://coderetreat.ning.com/events/global-day-of-coderetreat-in-copenhagen Cheers, /peter neubauer GTalk:      neubauer.peter Skype       peter.neubauer Phone       +46 704 106975 LinkedIn   http://www.linkedin.com/in/neubauer Twitter     

Re: [Neo4j] py2neo - GEOFF enhancements

2011-11-23 Thread Peter Neubauer
Looks great to me Nigel! I think this is a very good first step on parameters. Let me know when you are done with the Java code, would like to bring this into the @Graph annotations after our next milestone release, 1.6.M01. /peter On Tue, Nov 22, 2011 at 10:14 PM, Nigel Small

[Neo4j] How to boost performance?

2011-11-23 Thread Vinicius Carvalho
Hi there, I've posted a few days ago about the POC I'm doing here at my company. I have some initial numbers and I'd like to ask for some help here in order to promote neo4j here in LMI Ericsson. I've loaded a mySQL db with a really simple entity, that pretty much only represents a node and

Re: [Neo4j] Neo4j Spatial build / run problems

2011-11-23 Thread danielb
Hi Peter, I am more stuck today than yesterday oO I can't get the index to appear in the indexmanager any more. First I dropped the database and started from zero: C:\neo4j-community-1.5\binNeo4j.bat start SERVICE_NAME: Neo4j-Server TYPE : 10 WIN32_OWN_PROCESS

Re: [Neo4j] How to boost performance?

2011-11-23 Thread Peter Neubauer
Vinicius, in order to cut down on the REST JSON overhead (which you don't have in the RDBMS case), maybe you could look at just counting the results, something like START n = node(3) MATCH n--()--(x) return count(x) And see what happens? Cheers, /peter neubauer GTalk:      neubauer.peter

Re: [Neo4j] How to boost performance?

2011-11-23 Thread Vinicius Carvalho
Hi Peter, thanks, that indeed boosts to lower 10 ms, but we really need to access the nodes to perform the operations. I know that to be fair on a test, we should be running an embedded version of neo4j inside the appserver, after all the cache resides in the same JVM. But I'm not worried with

Re: [Neo4j] REST api get list of all relationship properties (unique)

2011-11-23 Thread Jure Zakotnik
Hi Peter, thanks a lot for your answer! Our alternative will be to keep a copy of the properties in memcached. Another option would have been to create a second graph, which is used only to store the properties in nodes/relationships, but from my view this has the disadvantage of different

Re: [Neo4j] How to boost performance?

2011-11-23 Thread Peter Neubauer
Vinicius, in real-world usages, you probably want to build a REST API that operates on domain and usecase level. Shuffling 6K nodes forth and back and resolve properties sounds not good to me, given the REST discovery overhead of the JSON representation. At the very least, you could do START n =

Re: [Neo4j] How to boost performance?

2011-11-23 Thread Vinicius Carvalho
Peter, I agree with you, would not be the ideal scenario, I would never access a REST api that way, at minimum pagination should be there. But we have this really specific case, where we need to have (not whole domain) but at least part of it (power, bearing, gain, frequency) to perform some

Re: [Neo4j] How to boost performance?

2011-11-23 Thread Michael Hunger
Vinicius, first: did you have any issues importing the data into Neo4j? second: your example used cypher which is not optimized for performance (yet!). This is in our plans for the next two releases of neo4j. So if you want to see the real performance of neo4j, please use the traversal

Re: [Neo4j] How to boost performance?

2011-11-23 Thread Rick Bullotta
The companion piece of this test is how fast you can get data *into* your database. Have you run a comparison of those two scenarios with MySQL vs Neo4J? We found Neo4J to be substantially faster with inserting/updating data as long as we executed our transactions in blocks of 50-1000.

Re: [Neo4j] How to boost performance?

2011-11-23 Thread Vinicius Carvalho
Hi Michael, thanks. The data load was fine, I've used your script with the BathInserter. Memory footprint was really slow, I think the peak was 200mb of heap usage. I did something really retarded and left a logger.info, which slowed things a bit, but the process was really smooth. Many thanks on

Re: [Neo4j] How to boost performance?

2011-11-23 Thread Michael Hunger
Please use EmbeddedGraphDatabase, EmbeddedReadOnlyGraphDatabase caches a snapshot of the data in its caches and doesn't get update-changes. Michael Am 23.11.2011 um 14:39 schrieb Vinicius Carvalho: Hi Michael, thanks. The data load was fine, I've used your script with the BathInserter.

Re: [Neo4j] How to boost performance?

2011-11-23 Thread Vinicius Carvalho
But wouldn't it mean that I need to have exclusive lock on the db? I would like to keep the server running pointing at the same data directory. Regards On Wed, Nov 23, 2011 at 1:50 PM, Michael Hunger michael.hun...@neotechnology.com wrote: Please use EmbeddedGraphDatabase,

Re: [Neo4j] How to boost performance?

2011-11-23 Thread Michael Hunger
Just make sure that it is just a snapshot of the data and doesn't update its caches. Otherwise you will run into synchronization issues. See also this thread and Tobias' explanations around it:

Re: [Neo4j] How to boost performance?

2011-11-23 Thread Vinicius Carvalho
Tks, for this test it's just a readonly graph now, so I don't think I'll run into synchronization issues. As we proceed with tests, I do hope that we will have one day is a HA version of neo4j. And as Jim's said in that thread, use it for other to read the graph. Regards On Wed, Nov 23, 2011 at

Re: [Neo4j] Neo4j Spatial build / run problems

2011-11-23 Thread Peter Neubauer
Daniel, try this: curl -X POST http://localhost:7474/db/data/ext/SpatialPlugin/graphdb/addSimplePointLayer -H Content-Type:application/json -d '{layer:geom, lat:lat, lon:lon}' curl -X POST http://localhost:7474/db/data/node -H Content-Type:application/json -H Accept:application/json -d '{lon:

Re: [Neo4j] How to boost performance?

2011-11-23 Thread Vinicius Carvalho
Hi Michael, this is going to be a newbie question, so please forgive me: I've re ran the tests with your examples, and using a embedded database. First thing: Whooping FAST! Mind blowing :D - 5ms But ... I got different results, same time though which is great, proves the exact thing that

Re: [Neo4j] How to boost performance?

2011-11-23 Thread Michael Hunger
You might run into uniqueness constraints. There are different uniqueness constraints that can be specified for a traversal, meaning how often is a node visited during one. (see here: http://components.neo4j.org/neo4j/1.6-SNAPSHOT/apidocs/org/neo4j/kernel/Uniqueness.html) You probably want to

Re: [Neo4j] How to boost performance?

2011-11-23 Thread Vinicius Carvalho
Tks once again Michael. Adding the Direction.Outgoing nailed it, I have the same dataset as the ones using cypher On the first one using the traversaldescription, I've modified to: TraversalDescription traversalQuery =

Re: [Neo4j] How to boost performance?

2011-11-23 Thread Linan Wang
hi, i noticed that you were using db.getNodeById to retrieve the starting node. the performance of this method call is quite different from real world apps especially those have external unique id. basically you need to index the external id yourself and get it via index call. besides, i'd suggest

Re: [Neo4j] Neo4j Spatial build / run problems

2011-11-23 Thread danielb
Hi Peter, first cURL doesn't like me: C:\curl -X POST http://localhost:7474/db/data/ext/SpatialPlugin/graphdb/addSimplePointLayer { message : Mandatory argument \layer\ not supplied., exception : java.lang.IllegalArgumentException: Mandatory argument \layer\ not supplied., stacktrace : [

Re: [Neo4j] Open Data Sets?

2011-11-23 Thread Anders Lindström
I found these readymade databases very helpful. Who made them from the start? I am interesting in getting a description of their content, i.e. the domain model, and how it was created. And does the cineast one come from https://github.com/neo4j-examples/cineasts btw? Thanks. -- View this

[Neo4j] Is it possible to have relationship attributes?

2011-11-23 Thread Stefan Arentz
Is it possible to add attributes to relationships? I would like to for example have a relationship like Person VISITED Building but then add a timestamp or additional attributes to the VISITED relationship between those two nodes. If this is not supported, what is a good alternative in the

Re: [Neo4j] Is it possible to have relationship attributes?

2011-11-23 Thread Rick Bullotta
Absolutely. And fairly unique to Neo4J. Plus you can even index and traverse relationships on those attributes (properties)! -Original Message- From: user-boun...@lists.neo4j.org [mailto:user-boun...@lists.neo4j.org] On Behalf Of Stefan Arentz Sent: Wednesday, November 23, 2011 12:34

[Neo4j] Neoclipse on OS X Lion

2011-11-23 Thread Stefan Arentz
When running Neoclipse on Lion (10.7.2) with the latest Java 10.6, the Eclipse menu bar is missing. Is this a known problem? Is there a workaround? S. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user

Re: [Neo4j] Is it possible to have relationship attributes?

2011-11-23 Thread Stefan Arentz
On 2011-11-23, at 12:35 PM, Rick Bullotta wrote: Absolutely. And fairly unique to Neo4J. Plus you can even index and traverse relationships on those attributes (properties)! Yeah, I should have gone straight to the JavaDoc. Good to see that Relationship is a PropertyContainer. I was

Re: [Neo4j] Is it possible to have relationship attributes?

2011-11-23 Thread Andreas Kollegger
Absolutely. And fairly unique to Neo4J. Plus you can even index and traverse relationships on those attributes (properties)! Yeah, I should have gone straight to the JavaDoc. Good to see that Relationship is a PropertyContainer. I was confused because the introduction documentation

Re: [Neo4j] Neo4j Spatial build / run problems

2011-11-23 Thread Peter Neubauer
Sorry, Cut and paste does not work, please remove the line breaks on my mail :-) /peter Sent from my phone, please excuse typos and autocorrection. On Nov 23, 2011 5:16 PM, danielb danielbercht...@gmail.com wrote: Hi Peter, first cURL doesn't like me: C:\curl -X POST

Re: [Neo4j] Is it possible to have relationship attributes?

2011-11-23 Thread Andreas Kollegger
I think you're right, Anders. With the page splits, it makes sense to reiterate. (abk) On Nov 23, 2011, at 10:15 AM, Anders Nawroth wrote: Sure, that information is only on the nodes page now I think ... should be on the relationships and properties pages as well of course. Thanks for the

Re: [Neo4j] Neo4j Spatial build / run problems

2011-11-23 Thread danielb
Hi Peter, I have posted the statements in 1 line, but no success with cURL. I think I have messed up the database at work, it was allready filled with nodes from OSM testing. I now started a new database at home and also included one additional line: http POST

Re: [Neo4j] Neoclipse on OS X Lion

2011-11-23 Thread Stefan Arentz
On 2011-11-23, at 12:35 PM, Stefan Arentz wrote: When running Neoclipse on Lion (10.7.2) with the latest Java 10.6, the Eclipse menu bar is missing. Is this a known problem? Is there a workaround? Ahh so it seems the tool does not actually have a menu bar. To open a database you have to go

Re: [Neo4j] Neo4j Spatial build / run problems

2011-11-23 Thread Peter Neubauer
Was lange währt wird endlich gut! Thanks for your feedback, will raise a few issues following this :) Cheers, /peter neubauer GTalk:      neubauer.peter Skype       peter.neubauer Phone       +46 704 106975 LinkedIn   http://www.linkedin.com/in/neubauer Twitter