Skip to content
Back

[SOLVED] How to set the query limit to unlimited

  • 0
  • Functions
  • Cloud
ianmont
3 Jul, 2023, 01:30

Im trying to get all the documents from a collection, but i notice the default limit of 25 that appwrite has but i want to make it infinite or at least a lot of documents is that possible?

TL;DR
Solution: The user wants to know how to set the query limit to unlimited in Appwrite cloud version. The solution is to use cursor pagination. Cursor pagination allows querying up to 5000 records at once in a self-hosted instance. However, in the cloud version, the limit is still capped at 100 records. There is currently no way to set the query limit to unlimited in the Appwrite cloud version.
Binyamin
3 Jul, 2023, 02:01

Are you querying the cloud or a self-hosted instance?

Binyamin
3 Jul, 2023, 02:02

In a self hosted one you can query upto 5000 at once.

Binyamin
3 Jul, 2023, 02:02

Then you can use cursor pagination. https://appwrite.io/docs/pagination#cursor-pagination

ianmont
3 Jul, 2023, 02:03

Im using cloud

ianmont
3 Jul, 2023, 02:04

thanks, just to know, how much is the limit of the cloud version?

Binyamin
3 Jul, 2023, 02:04

Then you still capped to 100 in the cloud versrion

Binyamin
3 Jul, 2023, 02:04

In the future when the cloud is gonna upgrade to latest version then you can have the 5K limit also in the cloud.

ianmont
3 Jul, 2023, 02:05

alright, thank you

Binyamin
3 Jul, 2023, 02:05

<a:agooglethumbsup:635256484682530825>

joeyouss
29 Jul, 2023, 17:12

[SOLVED] How to set the query limit to unlimited

Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more