Holders tab freezes

[vikiival]

On a huge collection

app freezes when you click on holders

[vikiival]

a bit of tinkering over Ku*

select
       ne.current_owner,
       count(ne.current_owner),
       SUM(e.meta::bigint / 1e12) FILTER (WHERE e.caller = ne.current_owner) AS bought,
       SUM(e.meta::bigint / 1e12) FILTER (WHERE e.current_owner = ne.current_owner) AS sold,
       max(e.timestamp)::date as updated
from nft_entity ne
left join event e on ne.id = e.nft_id and e.interaction = 'BUY'
where collection_id = '7e982817a2d2575031-C6N4I' group by ne.current_owner order by count(*) desc;

[vikiival]

If it fixes freezing let's go

[daiagi]

If it fixes freezing let's go

Also need to address flippers. When we have both can stop querying the entire collection event history => fix freezing

I'll have pr for that very soon

• https://github.com/kodadot/stick/pull/35