Strategies for handling large scale world (single player)

I’d love to know if you made any headway with this or figured out if this actually do-able since I am standing for the exact same dilemma.
As far as I understood streaming this is not really possible. Though I’d love to be wrong about that.