if Steemit becomes a world-famous platform, it won't be good if requests take hours to process.

Definitely! :-)
We have already discussed this in the witness channel. The database is very outdated and urgently needs to be updated. In preparation, I measured the query time of many methods and parameter combinations. We can use this to measure the improvements. Unfortunately, it is not possible to say whether and in what time improvements are achievable...