Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 User Profiles: Fixing Differences in Performance
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 25 September 2005 :  13:58:34  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
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.<


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

muzishun
Senior Member

United States
1079 Posts

Posted - 26 September 2005 :  16:29:26  Show Profile  Visit muzishun's Homepage  Reply with Quote
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.<

Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com)
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 26 September 2005 :  16:37:30  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
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.<


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

SiSL
Average Member

Turkey
671 Posts

Posted - 26 September 2005 :  16:44:40  Show Profile  Visit SiSL's Homepage  Reply with Quote
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.<

CHIP Online Forum

My Mods
Select All Code | Fix a vulnerability for your private messages | Avatar Categories W/ Avatar Gallery Mod | Complaint Manager
Admin Level Revisited | Merge Forums | No More Nested Quotes Mod
Go to Top of Page

muzishun
Senior Member

United States
1079 Posts

Posted - 26 September 2005 :  17:55:25  Show Profile  Visit muzishun's Homepage  Reply with Quote
Gotcha. Thanks.<

Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com)
Go to Top of Page

gpspassion
Junior Member

260 Posts

Posted - 25 June 2007 :  16:12:33  Show Profile  Visit gpspassion's Homepage  Reply with Quote
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 ?<
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 25 June 2007 :  17:41:07  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
Yep, that would be a way. Sometime ago I wrote an optimized search.asp for SQL Server. Have you tried using it?<


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

gpspassion
Junior Member

260 Posts

Posted - 25 June 2007 :  19:46:13  Show Profile  Visit gpspassion's Homepage  Reply with Quote
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.<
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 25 June 2007 :  19:56:17  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
No changes since then. If you're using my search.asp, paging could help too, cause I don't think it uses it now.
<


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

gpspassion
Junior Member

260 Posts

Posted - 29 June 2007 :  18:23:41  Show Profile  Visit gpspassion's Homepage  Reply with Quote
you mean displaying 15 resutls per page ? Yes, that would be useful, any pointers on how to implement that ?<
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 29 June 2007 :  18:28:22  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
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.<


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.1 seconds. Powered By: Snitz Forums 2000 Version 3.4.07