The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
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?
Postet den
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
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
Postet den
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.”
Search is your friend
“I was having a mildly paranoid day, mostly due to thefact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Postet den
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.
Postet den
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.
Postet den
Here you go, Weewee:
"post.asp"
"post.asp"
Code:
Look for the following lines (appx 1214-1217):
strSql = "SELECT MEMBER_ID, M_NAME "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE M_STATUS = " & 1
strSql = strSql & " ORDER BY M_NAME ASC "
Change them to say:
strSql = "SELECT MEMBER_ID, M_NAME "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE M_STATUS = 1 AND M_POSTS > 0"
strSql = strSql & " ORDER BY M_NAME ASC "
