You should really take the time to learn how storage and indexes work, and the difference between IO and CPU constraints on query performance. The database isn

You should really take the time to learn how storage and indexes work, and the difference between IO and CPU constraints on query performance. The database isn't magic... with the possible exception of elasticsearch, they will all disappoint you if you chuck data into them blindly and expect optimal performance on inefficient queries.