I have this strange question. I'm building a service that stores information into one table. That table has 20 columns. My database will have many billion rows. Right now I'm using Cassandra, but it takes ~5 seconds to return 22k rows which is about 4mb in size.
I have tried to optimize it, but it's not that easy. People in #cassandra said that Cassandra isn't very good for my service.. So here I am now.
It would be very helpful if you could help me find a perfect database for me.
It would be nice if it would be scalable, could host billions of rows and would have fast reading speeds.
If you decide to downvote this question, please let me know why you did that.