[SOLVED] the query only retuns 25 items from the database
const data = (await db.listDocuments(
import.meta.env.VITE_APPWRITE_DATABASE_ID,
import.meta.env.VITE_APPWRITE_COLLECTION_ID,
[Query.equal('userId', [userId])]
)) as unknown as { total: number; documents: UserDocumentProps[] | [] };
return data;
};```
in the console.log() it shows that the number of items is more than 70, but are only getting 25, and i have not limited anything from my side of the code, but i created a new account then uploaded a lot of files, and once it passes 25 the rest doesn't show. So someone help me this problem before i have to go class?
The default limit is 25. See https://appwrite.io/docs/pagination
Okay thank you, but in my use case, can't i make it limitless, becuase the file i been grouped into sections, meaning so making it into pagination means i have to change the design
You should always design with pagination in mind
Okay thank you
[SOLVED] the query only retuns 25 items from the database
For anyone else searching this page into the future, returning and unspecified amount of data from any endpoint is a terrible design choice.
You could accidentally try to return, say, 200 million records (probably in the terabyte range?), essentially DoS attacking your own server, and your own app.
Even if there's no reason for there to be large data set, someone could notice this, and maliciously create data in the collection to cause this issue.
If you revoked create access, and know there will be only 1000 records, for example, then just specify fetching 1000 records.
