Answer the question
In order to leave comments, you need to log in
Mysql or json, where is the best place to store frequently accessed data?
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 the question
In order to leave comments, you need to log in
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.
json, like xml, is a format for transferring information, not storing
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.
If the choice is mysql, then use the memory table type, flushing the data from time to time to disk.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question