Tsys the efficiency improvement of resource characteristics _ application Techniques

http://www.tsov.net/blog/article.asp?id=416
Tsys resource characteristics of the character storage, so in the update file to judge more trouble, directly to change the type to numerical type, convenient, efficiency also improved.
Such as:
The original method:
Sql= "SELECT Top 5 title,filepath,smallimg,shortcontent,addtime from View_newsinfo where class=61 and Instr (', ' + Speciality+ ', ', ', ', ') <>0 order by Id DESC "

The model for speciality in the modified database is numeric, the default value is 0, and after that,
Sql= "SELECT Top 5 title,filepath,smallimg,shortcontent,addtime from View_newsinfo where class=61 and speciality=29 order by Id DESC "

While
... where class=61 and speciality=29 ....
And
... where speciality=29 and class=61 ....
The efficiency of execution is also different,
The former query from the large class, and then query the characteristics, the latter is to query all the characteristics of the content, and then query the classification.
The former is more efficient than the latter.

Other:
2006-8-7 Day Supplements:
And then modify the file news_mdy.asp in line 120.
' Speciality=replace (Request ("speciality"), "" "," "" This is the original
Speciality=request ("speciality")