Is it appropriate to select mysql or mogodb? -Php Tutorial

Data needs to be captured and analyzed later. There are thousands of data records, and the query speed is faster. I don't know if mogodb is suitable? Can a complex SQL statement perform the same operation in mogodb? Now the data is saved in mysql, and the data needs to be captured during Query. Some analysis is required in the future.
There are thousands of data records, and the query speed is faster. I don't know if mogodb is suitable?
Can a complex SQL statement perform the same operation in mogodb?
Now the data is saved in mysql, and the query time is slow. The data is queried through multi-table connections.

Reply content:

Data needs to be captured and analyzed later.
There are thousands of data records, and the query speed is faster. I don't know if mogodb is suitable?
Can a complex SQL statement perform the same operation in mogodb?
Now the data is saved in mysql, and the query time is slow. The data is queried through multi-table connections.

If you need to Join many tables in one query, consider whether the table structure is reasonable, consider table sharding or data redundancy.
In addition, MongoDB query efficiency is faster than traditional relational databases. you can consider using MongoDB

I don't agree with the above answer. do you want to say that its query conditions can be arbitrary? What kind of query is powerful? I think it is inappropriate to look at the actual cases, not some functional points.

The subject should first introduce the data structure, how to process and obtain data restrictions ...... In this way, other people can answer your questions correctly.

Also, why do you think that "data needs to be captured" is someone's server? What db can you use?

Yes, you are right. you should select mogodb and mogodb as a document-type non-relational database. what you are best at is the query function.

Complex SQL statements need to be studied based on actual scenarios.

This type of question is hard to answer. it depends on the scenario business.

Can be considered, the previous version eats hard disk to eat memory

On the complex query, postgresql explosion mysql and mongodb, and the postgresql-9.4, also supports json format storage and query, you may wish to try postgresql