The 3 Essentials of the Learning Notes website in ASP and PHP language and database selection [text]
Last December, I began to set up a study of the blog site, because the blog site I have been contacted before, so in the site construction is still some experience, but let me some do not notice is: How to choose the system language, such as the choice of ASP and PHP; How to configure the database, For example, choose Access, MySQL, Microsoft's ms-sql, and if you want to choose, how is the version established? These are in the establishment of the environment should be pondered and considered good, once implemented, and then want to modify that is the big project.
To do this, I tested two systems of Zblog:
1, ASP is fixed with the Access database, I said last time, if the database content of not more than 10,000, then choose this database is very good, easy to operate, the requirements of the server environment is very low, and can generate static files, access speed and efficiency is not a problem.
2, the same ASP language system, if the amount of data is very large, for example, to reach 50,000, there is no doubt to use Ms-sql Microsoft's medium-sized database, large capacity, high access efficiency. Of course, when you choose, you have to pay attention to a problem, that is, the choice of SQL Server version, I have said before, SQL Server2005 and 2008 versions are more mature, But in the 2012 version will be a restart server or database system after the increment variable jump 1000 value problem, this problem and can not be solved, is the database exists bug, for us to establish a station, this is a very troublesome and difficult problem. So I recommend SQL server2005 and SQL server2008 version of Microsoft database.
Environment configuration: Asp+sql server+ reading subject, such as (
史记读后感http://www.simayi.net/dushubiji/2445.html司马迁史记读书笔记文章）
3, PHP language: Generally with MySQL database, and indeed with this open source database with the best, and the ability to process data is very good, but there is a problem, most people are not very understanding of the database, because there is no interface, operating on the Linux server needs a certain foundation, And I will not, so I generally choose the interface of the Windows operating system, in the operation of the database is more convenient.
The above 3 major points are in the establishment of learning the site, to pay attention to the place, and generally, the study of the site data is not very small, so the first time estimates will exclude aceess database, in addition, I think should choose to generate a pure static file site system is better, And zblog-php can't do that at the moment.
The 3 Essentials of the Learning Notes website in ASP and PHP language and database selection [text]
