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

Source: Internet
Author: User

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)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.