As title, if you want to do with tens of millions, the scale of hundreds of millions of even more news site, and hope to achieve id since, choose MySQL or directing a are not very suitable?
MySQL can't full text search, if you search for a key word, with the like '% XXX %' index cannot be used, if will be particularly slow, for tens of thousands of data is very slower;
Use mongo seemingly impossible id on the right,
Please choose what database, or use what means best?

CodePudding user response:

New York times is to use mongo database and news websites, specific what needs to be used in your system, or the business, and other a larger table associated words or a relational database is suitable:
1. MySQL like query, if adding indexes in the fields like, "* %", write SQL, is can use index; Full text search function can change a way of thinking, hundreds of millions of full-text retrieval will definitely affect the efficiency of data;
2. The mongo have ways of realizing database id since, many online example;

CodePudding user response:

reference 1/f, potatoes are not too familiar response:

mongo database is to use the New York times, is also a news site, specific what needs to be used in your system, or the business, and the other a larger table or a relational database is suitable:
1. MySQL like query, if adding indexes in the fields like, "* %", write SQL, is can use index; Full text search function can change a way of thinking, hundreds of millions of full-text retrieval will definitely affect the efficiency of data;
2. The mongo have ways of realizing database id since, many online example;

For the first point, in a way of thinking, how to do? I always can't data in MySQL, in order to use the full-text index, put the data on the es ~

CodePudding user response:

refer to the second floor and 2016 response:

Quote: reference 1/f, potatoes are not too familiar response:

New York times is to use mongo database and news websites, specific what needs to be used in your system, or the business, and other a larger table associated words or a relational database is suitable:
1. MySQL like query, if adding indexes in the fields like, "* %", write SQL, is can use index; Full text search function can change a way of thinking, hundreds of millions of full-text retrieval will definitely affect the efficiency of data;
2. The mongo have ways of realizing database id since, many online example;

For the first point, in a way of thinking, how to do? I always can't data in MySQL, in order to use the full-text index, put the data on the es ~

Can change the train of thought, such as using the database cluster? Can according to the year or region to store your news data depots? Can read and write, data should be read news, give full play to the role of the engine? Can you put some data in the es? Can you put the hot news cached? .