Limiting the time taken to return limited data

[geoff_thorpe]

I have a graphQL System query which has the potential to return a couple of thousand nested AWSresource nodes:

{
  System(code: "single-system-view") {
    name
    awsResources {
      name
    }
  }
}

By using the first pagination syntax (first:100) I can reduce the list returned to me to the first 100 records BUT I'm not seeing a huge change in performance. Does the underlying full query still run to get all the records but only returns what I asked for?

(my actual query is more complex with 10 sub types attached to each System - each of which can have hundreds of records).

Thanks
Geoff

[MuddyBootsCode]

I believe it still runs the full query. You may need to check into pagination or a custom cypher query with a range of ids.