query transaction by outpoint is too slow

[thebevrishot]

The api /spending/<txid>/<index> is too slow. After I examined the code seems like Blockbook iterates over all transactions that related to the address. It has a massive effect when a user tries to query an address that is related to a lot of transactions. For example in my case when a user tries to query by outpoint that related to an address that receives rewards every block, it need to iterate over 200k entries.

I believe we need an outpoint index to make this more efficient.

[martinboehm]

Hi, would https://github.com/trezor/blockbook/issues/251 help you?

[thebevrishot]

Yes, That's what I looking for. Thanks! However, do you have plan to include it to master branch soon?

[martinboehm]

The newly implemented -extendedindex option adds the feature.