[SOLVED] Data consumption

Absurd question about query performance.

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

TL;DR

Summary: The user is asking about data consumption and whether creating an edge function would decrease network consumption. They also have a question about saving data when making queries from the SDK or using a function. Solution: The user should create an edge function to decrease network consumption. As for saving data, it is unclear what they mean by "saving things locally" but using caching can help with query performance.

You mean caching?

Nop

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

TypeScript

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

Reply to this thread by joining our Discord

Reply on Discord