Can you share the output of "PROFILE MATCH ..."
Do you have an index on :City(name) ?
Also returning 5000 full details to the browser takes some time to transfer the
raw data depending on how much data you have stored for each.
If you have created the index, can you compare these queries:
> MATCH (n:City{name : 'hyderabad'})-[:CONTAINS]->(p:BusinessDetails) return
> count(*);
> MATCH (n:City{name : 'hyderabad'})-[:CONTAINS]->(p:BusinessDetails) return
> id(p);
> Am 21.12.2015 um 12:19 schrieb aditya mathur <[email protected]>:
>
> i am having a node "City" and many other nodes of "BusinessDetails" are
> connected to it with the relation "CONTAINS" from "City" to "BusinessDetails"
> , approx 5000 nodes of "BusinessDetails" are connected to a node of "City".
> When i am using the cypher query "MATCH (n:City{name :
> 'hyderabad'})-[:CONTAINS]->(p:BusinessDetails) return p" , its taking around
> 8 seconds to fetch the data. my question is why the fetching time is so high?
> how it canbe optimized.
>
> --
> 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]
> <mailto:[email protected]>.
> For more options, visit https://groups.google.com/d/optout
> <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.
