Yeah, that's much better. I didn't know that I could put a fulltext field in the WHERE clause. Thank you so much. What about the ORDER BY case? Is there any tweak I can do?
Matias. On Tuesday, July 7, 2015 at 4:46:02 PM UTC-3, Michael Hunger wrote: > > What you do is basically a hash join between the 650K nodes to match the > single n node. > > This is a better way, please try. > > START > n=node(6494) > MATCH n<-[:`host`]-x > > WHERE x.allContent =~ ".*Adobe.*" > > RETURN > count(DISTINCT x) as count > > > which only goes over the relationships of node n and checks the nodes on > the other side if they have Adobe in their "allContent" field. > > Michael > > Am 07.07.2015 um 20:14 schrieb [email protected] <javascript:>: > > Hi, i'm using version Neo4j 1.9 version and i'm running in to several > performance issues in a db with 1M nodes. > > First problem is with fulltext indexing, for me this should be very fast > but for example this query: > > START > n=node(6494), x=node:fulltext_index("allContent:Adobe") > MATCH n<-[r:`host`]-x > RETURN > count(DISTINCT x) as count > > is taking 497 secs the first time and 102 secs the second time, and the > count is just 32 nodes. I have aroung 650k nodes of type "x" > > Also I'm having some issues sorting that "x" type. This query: > > START > n=node(1133) > MATCH > n<-[r:domainType]-x > WITH DISTINCT x > RETURN ID(x) as nodeInstance > ORDER BY ID(x) > LIMIT > 10 > > is taking 4 or 5 secs. If I remove the ORDER BY clause it takes 20ms. > > Is there anything I'm doing wrong. What can I do to improve them? > > Thanks, > Matias. > > > > -- > 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] <javascript:>. > 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.
