Mysql or json, where is the best place to store frequently accessed data?

Question

MySQL

Actually, where is it better to store frequently changing and deleted data, to which a large number often needs access. users (there are more than 100k records in the table), will it be faster to store it in Json, then parse it through php or js?

Answer 1

And how are you going to store data in JSON? Speaking very simply, the json format is needed to transfer associative arrays between different languages. Or is there something I don't know? And the data in any way will have to be stored in the database, without it nowhere. Choose your base.

Answer 2

Better look towards memcache or redis

Answer 3

json, like xml, is a format for transferring information, not storing

Answer 4

In most cases, when the WEB is remembered, they choose the MySQL relational database, alas - this has happened historically. But in essence, the potential of this relational database is only 10% used, and that is at best ... By and large, we just need to store data that is completely unrelated to each other. In your case, I advise you to use MongoDB - it will perfectly cope with your tasks.

Answer 5

If the choice is mysql, then use the memory table type, flushing the data from time to time to disk.