Yes, it might make sense if you're Facebook or Amazon to do this stuff. For the rest of us, a single (reasonably optimised) database can scale up to thousands of hits per second. Probably more.
Also there's another downside to this approach: you lose the ability to do atomic transactions on the application's data.