http://www.tsov.net/blog/article.asp?id=416
The TSYS resource characteristics are stored in character type, so it is more troublesome to judge the update file. It is convenient and the efficiency is improved.
like:
Original method:
Sql="selectTop5Title,FilePath,SmallImg,ShortContent,AddTimeFromview_NewsInfowhereClass=61andInstr(','+Speciality+',',',',29,')<>0orderByIdDESC"
The model of Speciality in the modified database is numerical, with the default value of 0, after which,
Sql="selectTop5Title,FilePath,SmallImg,ShortContent,AddTimeFromview_NewsInfowhereClass=61andSpeciality=29orderByIdDESC"
at the same time,
....whereClass=61andSpeciality=29..
and
....whereSpeciality=29andClass=61..
The execution efficiency is also different.
The former queryes from the major categories and then querys the characteristics, while the latter querys all content characteristics and then querys the classification.
The former is more efficient than the latter.
Other:
2006-8-7:
Modify the line 120 of the file News_Mdy.asp
'Speciality=Replace(Request("Speciality"),"","") This is the original one
Speciality=Request("Speciality")