Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 User Profiles: Fixing Differences in Performance

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

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?
<

Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000 Version 3.4.07