chaingraph icon indicating copy to clipboard operation
chaingraph copied to clipboard
verified publisher icon bitauth

Change block insert trigger to use index lookup

Open mainnet-pat opened this issue 2 years ago • 0 comments

This PR changes the INNER JOIN condition to lookup inputs by indexed columns transaction_internal_id and outpoint_index. Otherwise full sequence scan is performed taking up to between 12-18 minutes on a fully synched instance.

mainnet-pat avatar Nov 14 '23 20:11 mainnet-pat