> but how does it scale

Usually sideways, but if you stack them, you might get some vertical.

I think 10000 is a lot enough for a queryable dataset. More of them is like computer generated things like logs etc.