anmot.Original post
Rank 1: Thread
Database read / write operations are very slow when running on cloud functions (appwrite cloud). Each operation takes 2-3 seconds and overall function execution takea around 3-6 seconds.
- Function execution
{"startTime":"Mon Dec 11 2023 18:45:30 GMT+0000 (Coordinated Universal Time)"}
[[1] get document by id] "1462.120"
[[4] create document in db] "2804.059"
function duration: 4854.733 ms
{"executionTime":4853,"endTime":"Mon Dec 11 2023 18:45:34 GMT+0000 (Coordinated Universal Time)"}
- Function execution
{"startTime":"Mon Dec 11 2023 18:51:11 GMT+0000 (Coordinated Universal Time)"}
[[2] third party API call] "148.158"
[[3] create document in db] "994.708"
[[4] create document in db] "2002.438"
function duration: 3776.766
{"executionTime":3776,"endTime":"Mon Dec 11 2023 18:51:15 GMT+0000 (Coordinated Universal Time)"}
3.Function execution
{"startTime":"Mon Dec 11 2023 18:53:26 GMT+0000 (Coordinated Universal Time)"}
[[2] third party API call] "121.156"
[[3] create document in db] "1284.590"
[[4] create document in db] "2619.728"
function duration: 4729.293
{"executionTime":4729,"endTime":"Mon Dec 11 2023 18:53:30 GMT+0000 (Coordinated Universal Time)"}
Summary
The execution of cloud functions is taking too long due to slow database operations. Creating a document without relationships takes around 300-400 ms per write operation. Creating child documents and parent documents with child document reference also have long durations. The function execution time ranges from 3-6 seconds.
Solution: To improve the performance, optimize the database operations and consider using relationships more efficiently. Additionally, upgrading to the Pro plan may help reduce operation times.