Oct 31, 2019

How much ram, how many cores, cpu speed, output format/accumulation... all material. Also one can cache the fee level of the tx to significantly optimize for such a query, but it’s an uncommon query. Finally one could index by fee level, which would be a huge optimization. It’s not clear if they are doing this, but scanning the entire store linearly even using multiple threads implies some sort of optimization if they have it down to 11sec.