Maximum Row Size

I'm busy creating a little side project which uses Appwrite as the Backend. I scraped a site and uploaded the data to the database, but I've reached 5000 rows (100 pages). I know there is a lot more data. Is that the maxmimum rows/pages allowed in Appwrite? I'm currently on the Free tier

No limit on num of rows. The limit is on the oparation In free you get 500k read And 250k writes.

And its not the amount of api calls But the number of rows you intract with.

Thank you. Must be something wrong with my script then. Just thought it too be quite a coincidence to stop at exactly 5000 rows.

Seems oddly matching with max fetchable rows at a time when doing list queries.

Is there any error saying, you cannot add more rows or do you see somewhere there is a total value of 5000?

Sounds indeed weird

The display seems to be capped at 5000 (100 pages), but I ran my script again and used cursor-based pagination to
count and the actual document count is 6,401. The documents were being saved correctly the whole time.

ok this is an inherent issue in appwrite / console sdk It seems to be from long ago. from my experince with using the console sdk 90% is the ⁨⁨total⁩⁩ related values are inacurate. some show total of life time (sites, database read write usages etc.) some show totally different count than actual count ( users count, database count, functions etc.) some show limited like this one. its best not to depend on it. cc <@564158268319203348> if you guys plan on fixing this later

don't ping eldad pls...

btw thanks for this I was thinking of some way to check if total from the list rows would have shown 5000 or actual total cause I may have seen someone talk about this .

They are busy enough

ah my bad :p

preferably don't cc anyone from the team, usually mods do that to avoid unneeded pings, but worst case, cc Aditya or atharva

They will cc the right people for the issue (or answer the question)

But yeah, I'd open a github issue preferably, report it as a bug, usually it gets quick attention. (unlike features 👀 )

ok I rarely ping cause I know about this. cause this issue makes the show total or not feature buggy

yea ic

I mean, it's all good now, eldad will see it when he can

and I dont think this will be fixed anytime soon cause this is from 2022-2023 and no body will want their mechine to calcualate millions of rows just because someone asked about it

the count is capped at 5K. because it can be very expensive to get the actual, real count. the data is still there, dw, just the count is capped.