Re: [Neo4j] Querying for nodes that have no relationhip to a specfic node

2010-07-28 Thread Alberto Perdomo
Hi everyone, I would have an SQL db for the app besides the graph db. I have users that I would store as nodes within the graph besides storing them in SQL as well. Within those nodes I store attributes like male/female, age or date of birth, etc. I would have one kind of relationship for

[Neo4j] Querying for nodes that have no relationhip to a specfic node

2010-07-28 Thread David Montag
Hi Alberto, Okay, interesting. You want to calculate some metric between pairs of users, so it's not a friend-of-a-friend scenario or anything like that, which would have been great in a graph db. This is just all/some pairs of random users. That you can do with your SQL db or neo4j or what ever

[Neo4j] Neo4j and JPA refactoring

2010-07-28 Thread Peter Neubauer
Hi there, I noticed the big update to the JPA implementation for Neo4j at https://svn.neo4j.org/laboratory/components/neo-persistence/trunk/ . Avishay, could you spread some light on what is changed and improved, and the current state of the project? Cheers, /peter neubauer COO and Sales, Neo

[Neo4j] Read-only transactions?

2010-07-28 Thread Tim Jones
Hi, Is it possible to mark a transaction as being read-only? It's taking a while for my transaction to shut down, even though there are no writes to commit. Thanks, Tim ___ Neo4j mailing list User@lists.neo4j.org

[Neo4j] Unable to build a master-slave system

2010-07-28 Thread George Ciubotaru
Hello, I'm trying to build a high availability system with neo4j as explained here: http://wiki.neo4j.org/content/Online_Backup_HA. In theory everything looks pretty simple and straightforward... but once I try to run the slave process I'm getting the following exception: Throwing away

Re: [Neo4j] Querying for nodes that have no relationhip to a specfic node

2010-07-28 Thread Alberto Perdomo
Hi David, But then you need to store the result. You can store these metrics as relationships in neo4j, and then just update them for each user when you recompute. You can find the user nodes via indexing. Maybe it's acceptable that some metrics are out of date, so you can just background

[Neo4j] Stumped by performance issue in traversal - would take a month to run!

2010-07-28 Thread Jeff Klann
Hi, I have an algorithm running on my little server that is very very slow. It's a recommendation traversal (for all A and B in the catalog of items: for each item A, how many customers also purchased another item in the catalog B). It's processed 90 items in about 8 hours so far! Before I dive

Re: [Neo4j] Stumped by performance issue in traversal - would take a month to run!

2010-07-28 Thread Rick Bullotta
Jeff, when you're doing your traversal/update process, how often do you commit the transactions? -Original Message- From: user-boun...@lists.neo4j.org [mailto:user-boun...@lists.neo4j.org] On Behalf Of Jeff Klann Sent: Wednesday, July 28, 2010 11:20 AM To: Neo4j user discussions Subject:

Re: [Neo4j] Stumped by performance issue in traversal - would take a month to run!

2010-07-28 Thread Rick Bullotta
Oh, and you DEFINITELY need more RAM! -Original Message- From: user-boun...@lists.neo4j.org [mailto:user-boun...@lists.neo4j.org] On Behalf Of Jeff Klann Sent: Wednesday, July 28, 2010 11:20 AM To: Neo4j user discussions Subject: [Neo4j] Stumped by performance issue in traversal - would

Re: [Neo4j] Stumped by performance issue in traversal - would take a month to run!

2010-07-28 Thread Tim Jones
I can't give too much help on this unfortunately, but as far as possibility 1) goes, my database contains around 8 million nodes, and I traverse them in about 15 seconds for retrievals. It's 2.8GB on disk, and the machine has 4GB of RAM. I allocate a 1GB heap to the JDK. Inserts take a little

Re: [Neo4j] Querying for nodes that have no relationhip to a specfic node

2010-07-28 Thread Mattias Persson
One benefit you of Neo4j is that you can get rid of these pesky background jobs and instead calculate such things on the fly quite fast, and not needing to store that calculated info at all. Tried it? 2010/7/28, Alberto Perdomo alberto.perd...@gmail.com: Hi everyone, I would have an SQL db for

Re: [Neo4j] Stumped by performance issue in traversal - would take a month to run!

2010-07-28 Thread Jeff Klann
Thank you both for your responses. - I will get some more RAM tomorrow and give Neo4J another shot. Hopefully that's a huge factor. - Tim, I like your algorithm trick! Would save a lot of reading/writing but would definitely require more memory due to the massive increase in # of edges. -

Re: [Neo4j] Stumped by performance issue in traversal - would take a month to run!

2010-07-28 Thread Rick Bullotta
Hi, Jeff. If you are committing after each item, it definitely will slow down performance. Start a single transaction, commit when you're all done the entire traversal, and report back the results. You will still see the changes you've made prior to committing the transaction, as long as you're

Re: [Neo4j] Stumped by performance issue in traversal - would take a month to run!

2010-07-28 Thread Jeff Klann
I don't think that's the problem. Here's why... When I was importing my data, it eventually slowed down to a crawl (though it was pretty fast at first). Someone pointed out that since I was trying to do it all in one transaction, it was filling the java heap too much. They suggested I commit

Re: [Neo4j] property value encoding

2010-07-28 Thread Davide
On Tue, Jul 27, 2010 at 22:29, Craig Taverner cr...@amanzi.com wrote: Mapping property values to a discrete set, and refering to them using their 'id' is quite reminiscent of a foreign key in a relational database. Yes, with a relational database I would create foreign keys and maybe bitmap