What database to use for messages on a web resource?

T

ti_cho2016-03-10 16:34:58

PHP

ti_cho, 2016-03-10 16:34:58

What database to use for posts on the site. Messages are displayed in dialogs like VKontakte. If you use the mysql database of the standard structure (Id from whom / Id to whom / Text / Send time / status) then when there will be 5,000,000 100,000,000 messages, the selection from the database will take a long time, or is it not? Are there more suitable bases for messages?

Reply

Answer the question

In order to leave comments, you need to log in

3 answer(s)

G

Grigory Esin, 2016-03-10
@xotey83

Are you sure you will have 5 quadrillion records in the table? Or how did you calculate it? Do not make me laugh!
In addition, you can always shard the data.

T

ThunderCat, 2016-03-10
@ThunderCat

Calculate the load, at least approximately, how many visitors you have at the peak, + what% growth, how many of them use chat, average dialing speed, display the number of requests per hour/minute/second, after that you will think about what to do, I suspect that the real load in the end it won't.

A

Andrey Pike, 2016-03-10
@AndyPike

And do not forget about the necessary keys for selections, this is the main thing.