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].
For more options, visit https://groups.google.com/d/optout.
