You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
postgres.go buildAccountQuery() current implementation when trying to filter on accounts that have some asset fetches all accounts (over 4e6 on mainnet) and filters them client side. Change to filtering inside postgres adding WHERE clauses after all the table JOINs to filter on [assetid] @> qaa.haid (TODO: double check I got the postgres array operator right and that this works with jsonb values). Similar for account with filter on app-id.
The text was updated successfully, but these errors were encountered:
postgres.go buildAccountQuery() current implementation when trying to filter on accounts that have some asset fetches all accounts (over 4e6 on mainnet) and filters them client side. Change to filtering inside postgres adding WHERE clauses after all the table JOINs to filter on
[assetid] @> qaa.haid
(TODO: double check I got the postgres array operator right and that this works with jsonb values). Similar for account with filter on app-id.The text was updated successfully, but these errors were encountered: