GQL Query Limit

Question

I have created a NDB Model

class Account(ndb.Model):
   accId = ndb.StringProperty()
   firstName = ndb.StringProperty()
   lastName = ndb.StringProperty()

So now I need to query on this model and get account Id's of all people having firstName as Mark. So I wrote the query...

acc_obj = Account.gql("WHERE firstName = :1","Mark")

But using the above query whenever I print count it limits to 1000 only.

print acc_obj.count()

I know that the count is more than 1000 but somehow the gql query fetches on 1000 entities at one time.

So why there is this limitation (explanation)?
And what is the other alternative to fetch all other records at once without using limit,cursor?

Alex Alex · Accepted Answer · 2018-11-06T16:23:11

It looks like there used to be a hard limit that got lifted:

But maybe it only got lifted for certain mechanisms and not others.

For example in the remote api-shell, the 1000 limit still exists

If you are able to recreate your query in NDB, you won't experience the limit: