Skip to content
Back

Implementing a rating system, how to queue queries for increment every 1 second?

  • 0
  • Databases
dummy_haiz
22 Jan, 2025, 13:58

Database will have 5 integer attributes, "5", "4", ..., there's a chance, very minute chance that thousands of people will give ratings at the same time.

To optimise it, I wanted to queue writes to 1 second, as writes will be focused on one row mostly.

Does appwrite support queuing increment updates to a row?

TL;DR
Developers want to implement a rating system with a queue for incrementing queries every second. They are concerned about optimization due to potential simultaneous ratings. They are wondering if Appwrite supports queuing increment updates to a row. Solution: Consider implementing a queue system in the code to handle increments at regular intervals without overwhelming the database. This can help optimize performance and prevent database saturation.
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