Add redundant table (next to _accounts_map_transaction_) which stores the most recent 1000 transactions per account. ### Algorithm: 1. take the transaction ids from current _accounts_map_transaction_latest_ 2. use the accounts and transactions from current block 3. merge the two transaction id arrays (per acc_id): `array_dedup_append('{8,3,2,1}', '{5,3}', 4) -> {2,1,5,3}` 4. update/insert into _accounts_map_transaction_latest_ table ``` SELECT array_dedup_append('{8,3,2,1}', '{5,3}', 4),-- {2,1,5,3} array_dedup_append('{8,3,2,1}', '{5,3}', 10000) -- {8,2,1,5,3} ```