The data needs to be fetched, and some analysis needs to be done later.
Data volume is very large thousands of W, want to query the time faster, do not know with mogodb suitable?
Can a complex SQL do the same thing in Mogodb?
Now the data is stored in MySQL, the query time is slow, the data are multi-table connection query
Reply content:
The data needs to be fetched, and some analysis needs to be done later.
Data volume is very large thousands of W, want to query the time faster, do not know with mogodb suitable?
Can a complex SQL do the same thing in Mogodb?
Now the data is stored in MySQL, the query time is slow, the data are multi-table connection query
If a query needs to Join many tables, consider whether the table structure is reasonable, consider the table or do data redundancy
In addition, MongoDB's query efficiency compared to the traditional relational database is very fast, you can consider using MongoDB
I do not agree with the above answer, you want to say that its query conditions can be arbitrary? Or what kind of query is powerful? I think it should be based on the actual case to see the right inappropriate, not to see some functional points
The main topic should first introduce the data structure, and how you want to deal with, get data restrictions and so on ... So that others can answer your questions correctly.
And you mentioned that "data needs to be captured" how do you think this is a server for someone else? What DB can you use to get around?
Yes, you're right. Mogodb,mogodb as a document type of non-relational database, the most good is the query function.
Complex SQL needs to be researched on its own, according to the actual situation.
This kind of question is not good to answer, depends on the scene business
MONGO3.0 can consider, go to the front of the version eat hard disk eat memory
On complex queries, PostgreSQL finishes with MySQL and MongoDB, and postgresql-9.4, also supports JSON-formatted storage and querying, you might want to try PostgreSQL