| T O P I C R E V I E W |
| bobby131313 |
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? |
| 15 L A T E S T R E P L I E S (Newest First) |
| bobby131313 |
Posted - 12 October 2012 : 21:28:03
Ahhh.... gotcha. Thanks. |
| ruirib |
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. |
| bobby131313 |
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? |
| Davio |
Posted - 12 October 2012 : 16:45:59
No, bobby. Why do you think it does? |
| bobby131313 |
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 " |
| Carefree |
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 |
Posted - 06 October 2012 : 19:48:08
Carefree, don't you have to add M_POSTS to the select? |
| Carefree |
Posted - 06 October 2012 : 11:47:55
Any time  |
| bobby131313 |
Posted - 05 October 2012 : 18:48:13
Dam you Carefree.... Grrr......
 |
| bobby131313 |
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! |
| Carefree |
Posted - 05 October 2012 : 18:36:01
Here you go, Weewee:
"post.asp"
|
| weeweeslap |
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. |
| bobby131313 |
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. |
| Shaggy |
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.
|
| HuwR |
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 |
