He’s saying you need to move the filters for the ‘p’ table in order to do what
you want. They need to be before your WHERE. The order of operations in sql
applies your join clause filters before the WHERE. The filters on your ‘s’
table need to stay in the WHERE. It’s the only time the ordering m
IMO blockchain won’t be doing anything for big data anytime soon. It is not
distributed (it’s “decntralized”). All blockchain data is replicated to ALL
nodes in the network. At the moment there is a game involving breeding cats
that is already clogging up ethereum blockchain. Blockchain might