Hello,
Previously I have had performance problems with my pop_profile.asp in especially in large topic / reply / member MS-SQL database where admins can see profiles fast, but users can not. Thanks to ruirib, I had this problem solved here
After installing Event Calender Mod, I have been living same problems (aka Admins see events fast like 0.55 second page timers, ordinary users are very slow like 20-35 seconds page timers) with my default.asp, and only code in Events Calender as SQL statement for default.asp is following code:
strSql = "SELECT T.TOPIC_ID, " & _
"T.T_SUBJECT, " & _
"T.FORUM_ID, " & _
"T.T_STATUS, " & _
"C.CAT_MODERATION, " & _
"F.F_MODERATION " & _
"FROM ((" & _
strTablePrefix & "TOPICS AS T " & _
"INNER JOIN " & _
strTablePrefix & "CAL_EVENTS AS E ON E.TOPIC_ID = T.TOPIC_ID) " & _
"INNER JOIN " & _
strTablePrefix & "CATEGORY AS C ON C.CAT_ID = T.CAT_ID) " & _
"INNER JOIN " & _
strTablePrefix & "FORUM AS F ON F.FORUM_ID = T.FORUM_ID " & _
"WHERE E.EVENT_DATE = '" & DatetoStr(dateHolder) & "'"
Or probably that might cause the slow load:
strSql = "SELECT E.EVENT_DATE, T.FORUM_ID " & _
"FROM " & _
strTablePrefix & "TOPICS T " & _
"INNER JOIN " & _
strTablePrefix & "CAL_EVENTS E ON T.TOPIC_ID = E.TOPIC_ID " & _
"WHERE E.EVENT_DATE BETWEEN '" & datetostr(DateSerial(Year(dateToDraw), Month(dateToDraw), 1)) & "' " & _
"AND '" & datetostr(DateSerial(Year(dateToDraw), Month(dateToDraw)+1, 1 - 1)) & "' "
If intRqCalForumID <> 0 then strSQL = strSQL & _
"AND T.FORUM_ID = " & intRqCalForumID & " "
strSQL = strSQL & _
"GROUP BY E.EVENT_DATE, T.FORUM_ID " & _
"ORDER BY EVENT_DATE Asc"
And ofcourse same problems with cal.asp as well. But code there is similiar.
Is there any chance to re-write this code with UNION statements since I'm inexperienced with usage of UNION?
Topic Locked
Posted - 08 October 2005 : 10:31:08
