T O P I C R E V I E W |
SiSL |
Posted - 24 September 2005 : 11:56:24 What may cause this?
Here some results,
As admin, my profile page (when looking at others profiles pop_profile.asp) is created like 0.8 seconds, as user 32.85 seconds... But there should not be that much difference between admin & user, right? I mean where I can try to find solution in codes?
What may cause this?
Mods I have installed: - Anti-spam mod (cant recall exact name) - Avatar mod - Poll mod - Active Users
NOTE: I have tried it several times and got it tried to some of my users.
TXT Version of POP_PROFILE.ASP
TXT Version of INC_PROFILE.ASP
Moved and renamed by ruirib< |
15 L A T E S T R E P L I E S (Newest First) |
ruirib |
Posted - 29 June 2007 : 18:28:22 You could try and use the paging in a normal search.asp to do it. It won't be any different... but it will also mean adding the code to change pages, which is not present.
Anyway, as it can be guess from a current discussion started by Podge in the SQL Server forum, using the normal Snitz paging may not help that much. I'd probably advise disabling that feature, at least for normal users.< |
gpspassion |
Posted - 29 June 2007 : 18:23:41 you mean displaying 15 resutls per page ? Yes, that would be useful, any pointers on how to implement that ?< |
ruirib |
Posted - 25 June 2007 : 19:56:17 No changes since then. If you're using my search.asp, paging could help too, cause I don't think it uses it now. < |
gpspassion |
Posted - 25 June 2007 : 19:46:13 If "sometime" is 3 years ago, yes I had ugraded to your search.asp MOD to make it display faster, if not I probably missed it ;-) I limit the search to subjects too.< |
ruirib |
Posted - 25 June 2007 : 17:41:07 Yep, that would be a way. Sometime ago I wrote an optimized search.asp for SQL Server. Have you tried using it?< |
gpspassion |
Posted - 25 June 2007 : 16:12:33 Stumbled onto this topic as I've noticed my CPU ressources going out of control when someone tries to use the "Find all non-archived posts by xxxx" feature. I have people with 10,000 messages so understandbly that's a lot to handle.
I was going to try this MOD, but it seems to be for "recent topics" mostly ? Any idea how the "Find all non-archived posts by xxxx" could be optimized ? Maybe limiting it to the 100 latest messages ?< |
muzishun |
Posted - 26 September 2005 : 17:55:25 Gotcha. Thanks.< |
SiSL |
Posted - 26 September 2005 : 16:44:40 quote: Originally posted by ruirib
My guess is that the change is only relevant when you have someone who has a lotta posts recently and it takes a lotta time for the server to navigate the recordset until it finds 10 topics to display.
True, such as the forum database I'm trying on, has 10K users with over 300K unarchieved posts which makes it almost impossible below 20 seconds for a 'Normal User' to check 10 messages after comparing forums that normal user has access or not.< |
ruirib |
Posted - 26 September 2005 : 16:37:30 My guess is that the change is only relevant when you have someone who has a lotta posts recently and it takes a lotta time for the server to navigate the recordset until it finds 10 topics to display.< |
muzishun |
Posted - 26 September 2005 : 16:29:26 Would this be something worthwhile for others to add into their pages? I haven't really experience any issues yet, but if this helps with performance, I don't really see how it could be a bad thing.< |
ruirib |
Posted - 25 September 2005 : 13:58:34 SiSL, that's great. I was thinking I had spent a whole lot of time for nothing. Likely you're one of the few people who can really check whether there is an advantage in coding the page like this.< |
SiSL |
Posted - 25 September 2005 : 13:54:38 ruirib: Found an error I made while pasting your code, it seems now it works like a charm :),
Thanks a lot
Here is some new results with "Recent Topics" on
This page was generated in 0.08 seconds. This page was generated in 0.17 seconds. This page was generated in 0.19 seconds. This page was generated in 0.2 seconds.< |
ruirib |
Posted - 25 September 2005 : 05:18:54 I don't know MySQL that well. Don't use this until I get the chance to test it with it.< |
modifichicci |
Posted - 25 September 2005 : 02:55:53 P.S.:This code is good only for Access or SQL Server. MySQL versions that support UNIONS (4.0+) should also be ok, BUT NO TESTING WAS DONE.
Mysql 4.0.25 I get an error: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Unknown column 'T.TOPIC_ID' in 'ORDER BY'
/forumlang/test/pop_profile.asp, line 565
and this is the sqlstr SELECT F.FORUM_ID, T.TOPIC_ID, T.T_SUBJECT, T.T_STATUS, T.T_LAST_POST, T.T_REPLIES FROM (FORUM_FORUM F INNER JOIN FORUM_TOPICS T ON F.FORUM_ID = T.FORUM_ID) WHERE (T_DATE > '20050826090251') AND (T.T_AUTHOR = 2) AND (T_STATUS < 2) AND (T_REPLIES < 1) AND F.F_TYPE = 0 UNION SELECT F.FORUM_ID, T.TOPIC_ID, T.T_SUBJECT, T.T_STATUS, T.T_LAST_POST, T.T_REPLIES FROM ((FORUM_FORUM F INNER JOIN FORUM_TOPICS T ON F.FORUM_ID = T.FORUM_ID) INNER JOIN FORUM_REPLY R ON T.TOPIC_ID = R.TOPIC_ID) WHERE (T_DATE > '20050826090251') AND (R.R_AUTHOR = 2) AND (T_STATUS < 2 OR R_STATUS < 2) AND F.F_TYPE = 0 ORDER BY T.TOPIC_ID DESC < |
SiSL |
Posted - 24 September 2005 : 20:34:05 I did some testing my avarage non-admin user see ~23-24 seconds..
With latest code, that didnt change actually. Above user & pass active for each code changes.
Is it from setup variables or something I had to do with settings of MSSQL to increase performance? < |