Recently have been researching and solving the Zblog database, because the early blog generally used small database, but today, the data gradually increased, access such as Microsoft desktop-level database has not been able to deal with the current amount of data, even if it is to build a blog, more than 20,000 of the data is the pressure of Alexander, It takes a long time to generate the data and has a significant impact on the user's access, which leads us to improve the problem.
Actual combat data: ZBLOG ASP Program +sqlserver2012 database,
(读后感http://www.simayi.net读书笔记)
Select Book and it reading notes theme, Welcome to Exchange!
Access database: It is recommended that a station with a small amount of data can be used, for example, within 20,000 data, to access and generate data without pressure, but in the future it becomes more and more troublesome.
SQL Server database: If you want to generate a pure static HTML file, and the amount of data is large, you can select this database, you can greatly improve access speed and save the resources of the server, which is very affordable and useful for webmasters.
MY SQL database: If you choose PHP website program, and the amount of data is also relatively large, then should be paired with this MySQL database, this is the classic collocation of Php+mysql database, is also the best solution.
But we have to pay attention to some problems: The program's anti-stress ability is not very strong, to do a small blog is OK, the volume of access or data is too large to carry the pressure!
SQL Server database is best to choose SQL server2008 or SQL server2005 version, because these two versions of the database is relatively mature, there will be no self-added column to restart the server after jumping 1000 problem, this is also a lot of webmaster is very worthy of concern.
The Zlbog of reading notes how do I choose ASP and PHP programs and database versions?