Skip to content
Init is coming / May 19 - 23
Back

How to reduce DB Reads?

  • 0
  • Databases
  • Cloud
armur
16 May, 2025, 03:57

I just noticed that I hit the 500k db reads limit on my very small next js app with the most data being present in one collection having around 50 documents.

I do use a lot of relations to link the collections. When creating a relation to another collection, I usually do a 2 way relationship. Is this the root cause?

Or could it be something like infinite loops on the app, calling the database?

Any suggestions on how to diagnose and fix?

TL;DR
- Developer hit DB reads limit on small Next.js app - Possibly caused by excessive relations between collections - Might be due to infinite loops in app calling database - Suggestions for diagnosis and fix: - Check relations for efficiency - Look for and fix any infinite loops - Consider optimizing queries and database structure
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