{"issue":{"state":"open","created_at":"2011-09-12T09:32:16Z","updated_at":"2011-11-29T12:49:35Z","user":{"gravatar_id":"47fd9c15d57a0c010619e37dda748519","id":545342,"url":"https://api.github.com/users/pablopareja","login":"pablopareja","avatar_url":"https://secure.gravatar.com/avatar/47fd9c15d57a0c010619e37dda748519?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"comments":14,"body":"I remember seeing in one of the mail-list discussions how relationships where not internally indexed by their names.\r\nThis is probably ok for most nodes or medium size graphs, however when it comes to supernodes (I read somewhere they were called that way) i.e. nodes with a large number of incoming/outgoing relationships, it can drastically affect the performance of traversals. \r\nSuch is the case when you have just a couple of relationships of the type you're interested in plus let's say a million or so of others. In that case, retrieving these two relationships can be a real overkill in terms of performance, not to mention the case where you find in the traversal a bunch of this 'supernodes'.\r\nI know there exists relationship indexing, however it doesn't seem to me like a general solution for this situation. In the project I'm working on for example, I would have to create tens of such indexes plus the pain of taking that into account for most traversals.","assignee":null,"number":19,"id":1622263,"pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"labels":[{"name":"feature","color":"d7e102","url":"https://api.github.com/repos/neo4j/community/labels/feature"},{"name":"kernel","color":"444444","url":"https://api.github.com/repos/neo4j/community/labels/kernel"}],"title":"Filter relationships natively by their name (performance not depending on number of total rels)","closed_at":null,"html_url":"https://github.com/neo4j/community/issues/19","url":"https://api.github.com/repos/neo4j/community/issues/19","milestone":null},"action":"created","comment":{"created_at":"2011-11-29T12:49:35Z","updated_at":"2011-11-29T12:49:35Z","user":{"gravatar_id":"6be19439f0eac5620e659dacfa12b645","id":225446,"url":"https://api.github.com/users/NielsHoogeveen","login":"NielsHoogeveen","avatar_url":"https://secure.gravatar.com/avatar/6be19439f0eac5620e659dacfa12b645?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"body":"Thanks for the summary, Mattias. It sound like a good solution to the problem. I am very pleased to see the API changes make it possible to retrieve the relationship types of a node and the count of relationship types/directions.\r\n\r\nDo you have any idea when this will be pushed to 1.6-SNAPSHOT. I am eager to try out this functionality.\r\n\r\nNiels","id":2929388,"url":"https://api.github.com/repos/neo4j/community/issues/comments/2929388"}}