[SOLVED] Data consumption

Absurd question about query performance.

Which case will save data between run query from SDK or with function?

You mean caching?

Nop

Then saving things locally? I don't understand your question at all 😅

users
    - id
    - full_name

companies:
    - id
    - name
    - address

company_members
    - id
    - user_id
    - company_id

transactions
    - id
    - author_id
    - amount
    - date

I want to get user info then him company also and all transactions.

For that, I make 3 queries (
1. get current user
2. use him id to get user data from db
3. again, use id to get the relative company
4. next, get all transactions
)

Each query as a cost in network connection consumption (4x)

If I create edge function to do that, the network consumption decrease?

You mean ?

For now, nope

It will not have any advantages

In case to protect cascade "post request" as "atomic transaction" it not have any advantage too ?

For example, if you need to make several post requests or actions at once, It could be a benefit

But there will not be any difference in data consumption reflected in the Appwrite console usage

Nice

[SOLVED] Data consumption