Earlier quoted context omitted.
I'm still flummoxed why people use blockchains for any kind of data or computation. Fundamentally isn't blockchain a tech stack built on a linked list with mandatory network calls in every operation? It seems purposefully inefficient. At least in theory it had a point (decentralized control). In practice, however...
Bitcoin doesn't even use linked lists (it's merkle trees). Similar with other coins.
But from the original bitcoin paper[1] I got the impression that to verify any particular transaction you need to traverse the whole list of blocks.