Taking Camel Xiangzi as an example to study the changes of database and indexing technology in the year 2018 [figure]

We all know, Camel Xiangzi is Lao She is an excellent novel, in the middle school stage we have studied it, so today, I take camel xiangzi as an example, to analyze the 2018 in the process of the construction station, for the database and indexing technology, Baidu and Google and other search giants change, In order to help us better optimize the database structure, less to take some detours.

Blog program I was contacted earlier, may be because I was small white, in the technical aspects of the process, I generally use a blog program, of course, you can choose Zlbog or WordPress can, this two program system is I prefer to use, But I don't like to build a station with PHP because there are some technical problems, especially with MySQL database.

OK, here are some things to say, the first is the environment configuration problem, focus on the program, System, database, site theme.

My blog is built with Zblog, named hundreds of notebook network, the program is very mature ASP language, database, or like the interface is more suitable for us to operate, so with the Microsoft SQL server2008 version, this version is more mature, I also analyzed before, About the 2008 version of the database after the cache restart the server will cause the self-increment field jumping 1000 and 10000 of the problem, this for our blog, the database is not much, jumping so big, is very headache. Take "camel xiangzi good word good words reading notes excerpt" For example, this is I published on February 23, 2018 an article, but on the search performance is better, this shows what problem? At least in the configuration and structure of the site, more suitable index, in the quality of data, in line with Baidu and Google and other giant door tastes. For this data on camel Xiangzi, I have summed up 3 advantages:

1, the data is summarized and published after the release of high quality, user experience is better, you can increase the stickiness of users, so that visitors retain longer browsing time, which is the advantage of lengthy articles.

2, the article has related pictures, graphic display, further enhance the experience, visitors in the visit, know what the article is about what, the image is generally better than the experience of text.

3, simple structure, in the process of index and crawl has a strong correlation, this is very important, many sites made a big mistake, for the book section and column, relevance is also to enhance the user experience one of the factors.

The above 3 points is I think very important skill, but many friends did not notice these, I in the analysis some big station, when I found their data in the collation of relatively strong, the user experience is really better, especially Sina, their editors are really too powerful, although these portals have not much original content, But their classification and user experience do a great job!

Taking Camel Xiangzi as an example to study the changes of database and indexing technology in the year 2018 [figure]