Hello,
I am trying to "pluck" i.e. retrieve from each item of an array parameter.
Given a users and posts parameters:
{
"users" : [ {
"name" : "Andy",
"position" : "Developer"
}, {
"name" : "Michael",
"position" : "Developer"
} ...
Hello,
I always find myself confused when profiling queries and find that at some point the number of DB hits increase somewhere along the execution path.
Take into consideration the following query:
MATCH (s:AudienceSegment {checksum: $checksum})<-[...
Hi again,
First, i would like to add an update on the above comment regarding nested UNWINDs, that this could be avoided by resetting cardinality.
I wonder how are parameters dealt with, are these considered Collections or Maps?
For instance creating...
Hello Michael,
We've been trying to replicate your results with no success.
The first time we run a query, its response time vary between 20s - 75s, any consecutive queries take ~ 200ms.
System
Node: Google Cloud 2 CPU - 32Gi RAM ( 29Gi allocata...
Following up on some of the earlier suggestions:
Using JOIN should help you as it can do two index lookups, esp. if you force an index use of Talent(iscore)
Tried to add an additional Index hint to Talent(iscore) but since we already have a JOIN hi...
Its ~20Gb, I presume it is too small yes, increased to 11Gi.
Would you be able to share the data with me for some internal testing?
Will send you a link to a backup on Slack.
Please also consider upgrading to 4.1 for quite a number of improvements...