I have a weird problem, my project on appwrite was using avarage 5-10k reads a day, it was okay, but suddenly last 7 days, reads are about 60k a day, the code hasnt changed and the traffic is the same, I need some help inspecting the problem, I will uprade my plan but this is ridiculous. Also I am suspecting some botting or something, and is there a way that I can add setting so that requests can be only sent from my website and nowhere else?
Appwrite already does that.
Check if you have put any wildcard platforms like * to allow all domains.
I actually think I did, but where to check it, i cannot find it
Overview-> platforms
And could this be the problem? I mean its extremely unusual that my usage goes from 10k a day to 60kβ¦
Probably no. Might be some relational column which gained more relational rows in the meanwhile causing this.
Wait, can you explain to me what do you mean by that? I am going to upgrade my plan but I really need to figure this out. I thought you count as a read every document fetched? What do you mean by rows and columns
Same thing Just in sql naming method And do you have any relational attributes in any table?
I am not aware, what do you mean by relational attributes? I thought its more of a NoSql db since its just documents with its fields
Is the high read count consistant?
Yes, it was consistently 5-10k which was ok for me, but last 7 days its constantly around 60k
Appwrite is SQL. but seems like you dont have any relational attribute I assume.
I use only 1 collection if you asked that
I dont
I added a couple of fields of data to the documents recently but it was after the jump of usage and also I thought it doesnt affect it
Would it help if I provide you with collection Id or something?
I use Appwrite for chat on my website, and I limited every user to fetch only 4 last messages
No Code will be better. Check if somehow in rare conditions the fetch is lopped more than once.
Like some useEffect hook
I already checked, its stable
I will provide you with ChatContext, just a sec
How many users?
Usually 10k active users a week I think
But it was really good with 5-10k reads a day
And suddenly 60k every day, thats what confuses me
Recommended threads
- Error With iOS Apps
I keep getting the below errors for my flutter app. The clients are registered and have been. This wasn't an issue a few hours ago. AppwriteException: AppwriteE...
- Backup policies think im on free tier
Cant create more than one policy as im told to ugprade, when clicking upgrade im taken to the upgrade page which confirms im already on pro
- Cant get rid of "get started"
Not that important, but annoying. No matter what I do I cant get the "Get started" to go away, ive added a bunch of web platforms and its just stuck.