Apr 30, 2024

Worked off a little technical debt today. Table sizing/bucketizing/config. Ran a couple full syncs, consistently 1.5 hours to block 840k. Discovered I used the output hash as opposed to the output script hash for the address table, so that will make the indexing slightly faster. Also wrote up a test case for a query against the Binance wallet address, with 1,380,169 payments. Once I resync with the proper address key I'll do some runs through that. I suspect it will collect all of the output links within a couple seconds. These are direct navigable (in memory pointers) to the output and its tx, which is then constant time searchable for the confirming block (if any), and the spending input, with direct link to its transaction (and search to block). We've got queries in place to find confirmed balance, etc.