How to generate a list of static articles when data volume is large

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

Some time ago made a classified information network, the beginning of the time to use the dynamic article List, and then find the source on the Internet to create a static list, each time to generate a full list, but the data for a little while, trouble came. We all know that static pages are good for search engines, but when the data is large, such as 10,000 data, 50 per page, 200 pages, if all regenerated will waste a lot of time and resources.

How to solve the problem of slow data generation of static articles list?

Later it appears that a number of large sites, a bit of inspiration, is the list in reverse order, usually the list of articles are the latest articles in the Index,index1, the old article ranked in Index2,index3....indexn, reverse is the new article placed in the sequence number of the big index inside, The old article is fixed in the number of small index inside, no need to regenerate, only to generate a new article index can be more stupid, I am a rookie, only the point of ASP has the master can give a better way to achieve the best.

My station http://www.fakuai.com is this realization, we can see, not too mature, is slowly improving.

1. Add two fields to the database, one record index number (such as Index_num), and another record whether this article has been generated into the index list (e.g. Feature, yes/No)

2. Each additional article, to determine the largest index number in the database, such as 50 articles per page, the database is now the largest number is 10, add new articles, to count the number 10 article how many, if enough 50, then the article number is 10+1=11, Less than 50 numbers or 10.

3, when the list is generated, only take feature of the article, and by its index number, generate a list, of course, to generate this list to include and it the same number of the other 49 articles

4, other problems: Because the Directory default page problem, to the maximum number of Indexn, name born into Index.html, an article may be compiled into a different list, such as the house: Big class is real estate, small class rental housing, then add the corresponding word

Paragraph is ok, such as INDEX_NUM1. Feature1 ...

The disadvantage is a lot of space, such as classified information network, the country has 343 prefecture-level cities, information classification of a total of more than 100, so if all generated by the words have more than 40,000 directory

(Reprint please specify: Send fast classification information)