Hi everyone,
I have a question about performing bulk data transformations efficiently in Appwrite. For example, let’s say I want to update all image URLs stored in a collection to change the domain (e.g., old-domain.com to new-domain.com).
The most straightforward approach is to use the Appwrite API or SDK to fetch documents, modify them, and update them back. However, this feels inefficient as each request passes through multiple layers, which could add significant overhead for large collections.
Traditionally, in systems like MySQL, I could directly run an update query on the database to get the job done quickly. So in Appwrite, is there a way to directly access and modify the database for such transformations ?
Or is it just that I’m overthinking 😅, and the performance difference between API-based updates and direct database manipulation is negligible for most use cases?
TL;DR:
Is using the Appwrite API/SDK for bulk updates inefficient for large-scale data transformations? Can users access the database directly for such tasks, or is the performance difference negligible?
