Dynamic Easy cms Random sort article title list increase rate

"Easy Web site Management System" is the Dynamic Network Technology Co., Ltd. based on asp+com Technology independent development of the Web site management system, is a perfect design and applicable to a variety of server environment efficient, new, fast and excellent web site solutions.

Dynamic Network Technology Co., Ltd. has a wealth of Web application design and development experience, especially in the Web site management system development and related fields, after long-term innovative development, mastered a set of algorithms, data structure to product security leading technology, making the "easy website Management system" in terms of stability, load capacity, Security and other aspects of similar products at home and abroad leading position. "Easy website Management system" humanized design concept, so that the erection of the site is extremely easy, the site management is extremely relaxed!

From the "Power article Management System" version 1.0 to today's "Dynamic and easy Web site management System" 2005 version, the system after several leaps of improvement, the function has been greatly improved and enhanced, widely adapted to enterprises, government, schools and other groups and individuals to build the station needs! Specially optimized modular architecture, powerful HTML generation function, convenient backstage management, people-oriented design concept ... Each place shows a distinctive classical creativity and the pursuit of perfect programming ideas.

As a commercial software PRODUCT, the "Dynamic Web site Management system" in the code optimization, operational efficiency, load capacity, security level, the function of the control and the tightness and so on, won the majority of users a good reputation. Dynamic Network Technology Co., Ltd. by virtue of long-term accumulation of rich web development and database experience, the spirit of excellence in the pursuit of perfect design concept, making the Dynamic Web site management system in a very short period of time with its distinctive personality characteristics from the domestic and foreign similar products from the fore. Through the optimization of efficiency and the optimal load capacity design of the Dynamic Web site management system, has been more and more experts in the industry and authoritative enterprise recognition.

Recently I have a site on the content of more than 100,000 pages, as has been in Baidu and Google and other major search engines on the low rate, so today suddenly sprouted an idea, can write a random call on the homepage of the article database designated number of URL tags to increase the display rate to the search engine, So every time the search engine spiders in the index, can see different pages, can increase the likelihood of crawling, and then improve the rate of inclusion.

One, let the page display randomly arrange the article title list Method 1 (for SQL database)

Because of the use of the Dynamic Web site management system, so consulted the rain zhe, found that the idea is feasible, there are other people have written the corresponding label, but the efficiency is relatively low, rain Zhe gave a simple solution:

First, add the dynamic tag directly in the background, and the query statement is: Select top articleid,title from pe_article where Deleted = {$PE _false} and Status =3 order by NEWID ( DESC, if you want to randomly invoke 200 articles, change top 100 directly to top 200.

Second, set the label content (that is, add a dynamic label to the second step of the loop content) is: {loop}{infobegin}{$Field (0,geturl,article,3)}

{Infoend} {/loop}.

Finally, note that, because the dynamic label has a cache, the generation must first update the next site cache.

After the solitary heroes of the field test, the above scheme is fully passed, the effect is perfect:).

Because the custom label has only SQL to use random tags, the above scenario is only suitable for dynamic SQL versions. The main idea is to use the NEWID () in the query statement, the sort on the random to achieve.

Two, let the page display randomly arrange the article title list Method 2 (suitable for SQL database)

Netizen Small Code Brother provides another one to let the page display randomly arrange the article title list method, lets the website page display the article title list to be able to refresh with the page, simultaneously also has the change. This program can be detailed to a section of a channel random article:

The steps are simple:

1, add Tags: {$MY _ produce a random article in this month's column}. The label name here can be customized.

2. The query statement is written as: Select Top articleid,classid,title,updatetime from pe_article where Channelid ={input (0)} and DateDiff (Day, Updatetime,getdate ()) <30 and Deleted=0 and status=3 order by NEWID ()

3, the label content is written as:

{Loop} {Infobegin}

{$Field (2,text,22,2,1)}

{Infoend} {/loop}

4. Template call

Where the page needs to be written {$MY _ produces a random article in this month (1002)}, 1002 of which corresponds to our dynamic channel ID, can be changed according to their own actual. In the query statement DateDiff (Day,updatetime,getdate ()) <30 in the "30" is the query one months of the article, this value can be adjusted according to the actual situation of the site.

Three, let the page display randomly arrange the article title list Method 3 (for Access database)

It is necessary to note that the above solitary heroes and friends of the two solutions are given only can be applied to the SQL database, not suitable for the AC database. If you are using the easy access version of the random article list, you can see the technical solution provided by the Netizen Arko:

First of all, it should be noted that at this time in the background custom label management is a new function tag, tag name can be named {$MY _ random article}.

The query statement is set to: ("Top10" in 10 is to query the number of articles, you can change their own, but not recommended to change too much; If you do not want to call the column, but call a channel under the article, then you can put Channelid in ({input (0)}) and ClassID in ( {input (1)}) Modified to: Channelid in ({input (0)}), the corresponding call tag is: {$MY _ random article (channel ID)}; " DateDiff ("D", date (), updatetime) <7 "7 refers to the query of the last 7 days of the article, as needed to modify;"

Select Top Articleid,classid,title,updatetime from Pe_article where Channelid to ({input (0)}) and ClassID in ({input (1)} ) and DateDiff ("D", date (), updatetime) <7 and deleted={$PE _false} and Status=3 order by right (CStr (Rnd Rnd (-timer ()) *100)) *1000*now (), 2);

The label content is set to:

{Loop} {Infobegin}

{$Field (2,text,44,2,1)}

{Infoend} {/loop}

Secondly, in the appropriate position in the template to add {$MY _ random article (channel ID, column ID) can be invoked, where the channel ID, column ID can be modified according to their actual.

It should be noted that good results in the loss of performance in the premise of implementation, no more than the dynamic label of SQL database, this tag code efficiency is very low, although the label to ensure the randomness, if it is generated static, the generated every page is different, each generation is different. But the virtual host user when the CPU peak is less than 5%, and you have to generate a static page, the generation of more than 700 articles will likely cause the process as a machine. It is recommended that when generating a large number of static pages, look for fewer visitors and try to generate as few as possible. You can also modify the config.asp files in the dynamic installation directory:

Const MAXPERPAGE_CREATE = 10 ' One generation quantity, change him smaller, const SLEEPTIME = 3 ' Generation interval, make him bigger.

Reference documents:

Site collection rate of concern: http://www.make-dress.com.cn, http://www.gongzuofuf.com