Store amount and owner (not program) of token account

[muhitrhn]

Is it possible to store amount and owner of token account in spl_token_owner_index table and update it same way the items of account table is kept up to date? @lijunwangs

[lijunwangs]

It is possible. But since we already have the information, you can just join the two tables: spl_token_owner_index and account table.

[muhitrhn]

Hmm could do that but the amount of tokens in the token account is not exposed in a column. Will it take too much space in database if all the accounts are stored with their deserialized data?