theory is one thing but the cpu cache is the real bottleneck here... here is a small visual breakdown of how these arrays look in memory and why pointer chasing is so expensive compared to the actual logic:
https://vectree.io/c/json-array-memory-indexingbasically the double jump to find values in the heap is what slows down these tools most