| Author |
 Topic  |
|
|
bobby131313
Senior Member
USA
1163 Posts |
 Posted - 26 February 2012 : 08:09:29
|
| I'm cruising up close to 20K members. That list takes what seems an eternity to load when editing forum properties. It takes around thirty seconds to generate the page because of the "Allowed Member List". Has anyone converted this to a text box to add a member instead of pulling the entire list? |
Switch the order of your title tags |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 26 February 2012 : 13:35:01
|
I'm pretty sure there was a MOD for this at some pont, have you tried looking on SnitzBitz ?
I would say however that if it is taking 30 seconds with 20K members then it is the server causing the slowness not the 20K members, we have > 30K and it takes approx 5 secs to open the page |
MVC .net dev/test site | MVC .net running on Raspberry Pi |
 |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 27 February 2012 : 05:38:51
|
What version of the forum are you running, Bobby? Have a look at this topic and check that the changes mentioned have been made in your code.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 28 February 2012 : 09:28:01
|
| Shaggy that code was not there, I added it. It did improve the speed for normal posting but unfortunately not for forum editing. I also did not see anything on Snitzbitz. |
Switch the order of your title tags |
Edited by - bobby131313 on 28 February 2012 09:28:23 |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 05 October 2012 : 17:08:54
|
| We added something to the query that it would only return the names of those who had at least a post count of 1. Since most of my site members don't post in the forum, that reduced the loading to under a second from over 30 seconds. Unfortunately, I'm no coder so I wouldn't know the first place to find that piece of code bt I hope that idea gets you going. |
coaster crazy |
|
|
|
Carefree
Advanced Member
Philippines
4217 Posts |
Posted - 05 October 2012 : 18:36:01
|
Here you go, Weewee:
"post.asp"
|
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 05 October 2012 : 18:47:04
|
Hah! Genius!
Changed...
'#################################################################################
'## Allowed User - listbox Code
'#################################################################################
strSql = "SELECT MEMBER_ID, M_NAME, M_POSTS "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE M_STATUS = " & 1
strSql = strSql & " ORDER BY M_NAME ASC "
To
'#################################################################################
'## Allowed User - listbox Code
'#################################################################################
strSql = "SELECT MEMBER_ID, M_NAME, M_POSTS "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE M_STATUS = 1 AND M_POSTS > 49 "
strSql = strSql & " ORDER BY M_NAME ASC "
Now it only lists members with 50 posts (minimum for special forum access) or more and only takes about 3 seconds.
Thanks! |
Switch the order of your title tags |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
|
|
Carefree
Advanced Member
Philippines
4217 Posts |
Posted - 06 October 2012 : 11:47:55
|
Any time  |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
|
|
Carefree
Advanced Member
Philippines
4217 Posts |
Posted - 12 October 2012 : 06:12:10
|
quote:
Originally posted by bobby131313
Carefree, don't you have to add M_POSTS to the select?
quote:
strSql = strSql & " WHERE M_STATUS = 1 AND M_POSTS > 0"
|
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 12 October 2012 : 15:51:21
|
Yeah, but doesn't...
strSql = "SELECT MEMBER_ID, M_NAME "
need to be...
strSql = "SELECT MEMBER_ID, M_NAME, M_POSTS " |
Switch the order of your title tags |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 12 October 2012 : 18:36:36
|
Hmmm... just thought you had to select it from the DB before you could use it.
So if you use it in the "where" part that's good enough? |
Switch the order of your title tags |
Edited by - bobby131313 on 12 October 2012 18:37:59 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 12 October 2012 : 18:52:15
|
| In the SELECT clause you need only to include the columns you want to have in the resulting recordset. You don't need to include a column that you will only use to apply a condition, like in this case, Bobby. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
|
| |
Topic |
|
Editing a forum with a boatload of members..
