Re: [Neo4j] Re: Why is Neo4j slower(totally dead) with many nodes and relationships in lower specification of pc/notebook while MySQL is not?

2014-03-24 Thread Rio Eduardo
yes I want to return all nodes to testing neo4j. And I just tested it in higher specification of pc and it said "Resultset too large (over 1000 rows)". And I just tested it again in Neo4j Shell and it said "68351 rows and 1580 ms" and when I open http://localhost:7474/db/data/transaction/commit

Re: [Neo4j] Re: Why is Neo4j slower(totally dead) with many nodes and relationships in lower specification of pc/notebook while MySQL is not?

2014-03-24 Thread Michael Hunger
Please read what I wrote. And then please answer/ask again. On Tue, Mar 25, 2014 at 4:34 AM, Rio Eduardo wrote: > My Neo4j Version is 2.0.1 and yes I'm using Neo4j 2.0.1 browser to return > back all 60,000 nodes. So I should use Neo4j Shell to return many nodes? > > > On Tuesday, March 25, 2014

Re: [Neo4j] neo4j 2.0 import

2014-03-24 Thread Michael Hunger
Actually there are two options with the batch-importer: #1 faster: you drive the node-id generation externally using :id on a column with dedicated node-ids and then for the relationship use start:id and end:id as first columns pointing to the node-id's from your nodes files #2 use indexes, slowe

Re: [Neo4j] Re: Importing facility in neo4j

2014-03-24 Thread Michael Hunger
Best provide an absolute path On Tue, Mar 25, 2014 at 12:48 AM, Silvia wrote: > I actually do have a very silly question about importing, and it's related > to the location of the csv file.FYI, I have a windows machine. So where > should I place the csv and how can I refer to it in the import

[Neo4j] Re: Why is Neo4j slower(totally dead) with many nodes and relationships in lower specification of pc/notebook while MySQL is not?

2014-03-24 Thread Rio Eduardo
My Neo4j Version is 2.0.1 and yes I'm using Neo4j 2.0.1 browser to return back all 60,000 nodes. So I should use Neo4j Shell to return many nodes? On Tuesday, March 25, 2014 1:50:28 AM UTC+7, Kenny Bastani wrote: > > Please provide your Neo4j version and details about how you are > interacting w

[Neo4j] Re: Importing facility in neo4j

2014-03-24 Thread Silvia
I actually do have a very silly question about importing, and it's related to the location of the csv file.FYI, I have a windows machine. So where should I place the csv and how can I refer to it in the import command? I am using (or trying to use) load csv. Thanks for any help and guidance! S

[Neo4j] neo4j 2.0 import

2014-03-24 Thread natalie Yosef
hey, i'm trying to import csv files to neo4j i have one csv with 7,000,000 rels and another with 250,000,000 rels i tries importing the data with the java api but after 7,000,000 rels it gets stack on "unable to get transaction" and also it takes lots of time - about 2 days i tried using the bat

Re: [Neo4j] Re: all possible paths between two users

2014-03-24 Thread Krishna Shetty
Sure. Finally using: MATCH path=(:user{guid:3830})<-[*3..5]->(:user{guid:2231}) WHERE NONE(n in nodes(path)[1..-1] WHERE n:user) RETURN path; Query was taking very long time with: MATCH p=(u1:user { guid: 123 })-[*]-(u2:user { guid: 124 }). Thank you. On Tuesday, March 25, 2014 7:24:38 AM UT

Re: [Neo4j] Re: all possible paths between two users

2014-03-24 Thread Michael Hunger
And please don't cross post between the google group and stackoverflow. Thanks a lot On Mon, Mar 24, 2014 at 7:55 PM, Kenny Bastani < kenny.bast...@neopersistence.com> wrote: > The following query will find all possible paths between two nodes. > > MATCH p=(u1:user { guid: 123 })-[*]-(u2:user {

Re: [Neo4j] Re: Why is Neo4j slower(totally dead) with many nodes and relationships in lower specification of pc/notebook while MySQL is not?

2014-03-24 Thread Michael Hunger
Why would you want to return all nodes in the first place? If you really want to do that, use the transactional http endpoint and curl that streams the response: I tested it with a db of 100k nodes, it takes 0.9 seconds to transfer them (1.5MB) over the wire time curl -o result.json -d'{"stateme

Re: [Neo4j] Importing facility in neo4j

2014-03-24 Thread Michael Hunger
What did it output? Did you use the correct version for your server? What is your server version? Can you enable exception reporting in the shell with export STACKTRACES=true and re-run it? On Mon, Mar 24, 2014 at 3:30 PM, Jyoti Yadav wrote: > Hi Michael .. > > Thanks for your active reply.. >

[Neo4j] Re: Importing facility in neo4j

2014-03-24 Thread Javad Karabi
jyoti, here is an example of how i import (json/yaml data) into neo4j: github.com/karabijavad/congress-graph of course, if the data is CSV, you can simply do: CSV.foreach instead of YAML.load_file this will do a batch insert of data On Monday, March 24, 2014 6:15:39 AM UTC-5, Jyoti Yadav wrote:

[Neo4j] Re: Why is Neo4j slower(totally dead) with many nodes and relationships in lower specification of pc/notebook while MySQL is not?

2014-03-24 Thread Javad Karabi
make sure you are setting up your indexes. this was something that i did not do at first, but once i realized how important it was, my queries were incredibly fast. also, profile your queries by prepending "profile " to the query, and try to decrease _db_hits. if you can provide the output of "p

[Neo4j] Re: all possible paths between two users

2014-03-24 Thread Kenny Bastani
The following query will find all possible paths between two nodes. MATCH p=(u1:user { guid: 123 })-[*]-(u2:user { guid: 124 }) RETURN nodes(p) as path Thanks, Kenny On Monday, March 24, 2014 9:12:15 AM UTC-7, Krishna Shetty wrote: > > I have a network, in this an user can be connected in any p

[Neo4j] Re: Why is Neo4j slower(totally dead) with many nodes and relationships in lower specification of pc/notebook while MySQL is not?

2014-03-24 Thread Kenny Bastani
Please provide your Neo4j version and details about how you are interacting with the database. Are you using the Neo4j 2.0 browser to return back all 60,000 nodes? Typically this amount of data, when loaded into memory in the browser, will cause for a timeout, which results in an unknown except

[Neo4j] Why is Neo4j slower(totally dead) with many nodes and relationships in lower specification of pc/notebook while MySQL is not?

2014-03-24 Thread Rio Eduardo
I'm testing my thesis which is about transforming from relational database to graph database. After transforming from relational database to graph database, I will test their own performance according to query response time and throughput. In relational database, I use MySQL while in graph data

[Neo4j] all possible paths between two users

2014-03-24 Thread Krishna Shetty
I have a network, in this an user can be connected in any pattern as shown below. *(u:user{guid:123})*<-[r]-(mg)<-[r2]-(c) *(**u:user{guid:123}**)*<-[r]-(mg)<-[r2]-(c)<-[r3]-(mg2)<-[r4]-(c2) *(**u:user{guid:123}**)* <-[r]-(mg)<-[r2]-(c)-[r3]->(mg2)-[r4]->(c2)<-[r5]-(mg3)<-[r6]-(c3) *(**u:user{guid

Re: [Neo4j] Importing facility in neo4j

2014-03-24 Thread Jyoti Yadav
Hi Michael .. Thanks for your active reply.. I tried through neo4j shell tools.. I referrred following link. https://github.com/jexp/neo4j-shell-tools#import-data-into-your-neo4j-database-from-the-neo4j-shell-command After installing neo4j shell tools, I executed following command 1.auto-ind

[Neo4j] Gremlin Plugin - Extremely slow on Neo4j 2.0.1

2014-03-24 Thread Effy Teva
Hi, I've made some tests today, and found out Neo4j 2.0.1 Gremlin Plugin works much slower than the one included with Neo4j 1.9 (~60 times slowed). My test results are available here: https://groups.google.com/forum/#!topic/gremlin-users/_PZT5HMKUyA Is there any special reason for that? Might b

Re: [Neo4j] Importing facility in neo4j

2014-03-24 Thread Michael Hunger
Could you detail what you've done and tried? You might want to have a look at: http://neo4j.org/import and http://blog.bruggen.com/2013/12/untying-graph-database-import-knot.html?view=sidebar Cheers, Michael On Mon, Mar 24, 2014 at 12:15 PM, Jyoti Yadav wrote: > Hi Folks.. > > Have anyone work

[Neo4j] Importing facility in neo4j

2014-03-24 Thread Jyoti Yadav
Hi Folks.. Have anyone worked with importing csv files( node file and relationship file ) into neo4j??? I tried, but having some issues.. Pls reply.. Thanks.. -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop

Re: [Neo4j] Re: Add custom logback config to unmanaged extension

2014-03-24 Thread Michael Hunger
I think it would still be worth it. As people will run into this (and it also applies to other custom logback config for the server in general not just for unmanaged extensions). And it gives you some good cred and google might more easily find it then. We still add some notes about it to the Man

[Neo4j] Re: Shortest Path Algoritm with cost?

2014-03-24 Thread Antonio Grimaldi
i tried to execute this cypher query : StringBuilder sb = new StringBuilder("START startNode = node(269604), endNode = node(269605) MATCH path=(startNode)-[:CAR_MAIN_NODES_RELATION*]-(endNode) RETURN path AS shortestPath, reduce(cost=0, rel in relationships(path) | cost + rel.edgeLength) AS t

[Neo4j] Re: Shortest Path Algoritm with cost?

2014-03-24 Thread Antonio Grimaldi
So, how can I change this default behavior for Dijkstra's algorithm, to allow for returning paths with different and diminishing cost? Thank you Antonio Grimaldi -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop

Re: [Neo4j] Re: Add custom logback config to unmanaged extension

2014-03-24 Thread Bo Ferri
Hi Michael, for sure, I can do this. However, I'm not sure whether this (at the end somehow small) issue is a blog post worth. I posted this topic on stackoverflow as well, see http://stackoverflow.com/questions/22449301/add-custom-logback-config-to-neo4j-unmanaged-extension. Okay, my answer

Re: [Neo4j] Re: Shortest Path Algoritm with cost?

2014-03-24 Thread Mattias Persson
There's a limiter in Dijkstra and A* that will stop the iterator after all paths with the lowest cost (if there are multiple) have been returned. This could and probably should be changed to allow for returning paths with diminishing cost as long as the user of the iterator pulls items. 2014-03-2

Re: [Neo4j] How to update Neo4j HA cluster with offline generated graph without downtime

2014-03-24 Thread Rickard Öberg
On 3/24/14, 15:05 , Kiran Kumar Reddy Sathi wrote: Hi, I have a HA cluster with 1 master and 2 slaves. We want to generate the whole graph daily using batchinsert. Once the graph is created offline, we want to update the HA cluster. I tried following approach but it didnt work. Looks like the m

[Neo4j] How to update Neo4j HA cluster with offline generated graph without downtime

2014-03-24 Thread Kiran Kumar Reddy Sathi
Hi, I have a HA cluster with 1 master and 2 slaves. We want to generate the whole graph daily using batchinsert. Once the graph is created offline, we want to update the HA cluster. I tried following approach but it didnt work. Looks like the master is overriding the new graph in slave. 1. sto