Data need to be captured and analyzed later.
The amount of data is quite large, thousands of W. When you want to query, the speed is faster. Do you know if mogodb is suitable?
Can a complex sql do the same in mogodb?
Now the data is stored in mysql, the query time is relatively slow, and the data are all multi-table connection queries.
If a query requires many tables to be Join, it is necessary to consider whether the table structure is reasonable, whether to divide the tables or to make data redundancy.
In addition, MongoDB’s query efficiency is very fast compared with the traditional relational database. You can consider using MongoDB.