| Author |
 Topic  |
|
Jeepaholic
Average Member
USA
697 Posts |
 Posted - 26 December 2002 : 22:27:06
|
The main members page is timing out consistently. Just an FYI.
=================
Active Server Pages error 'ASP 0113'
Script timed out
/forum/members.asp
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
=================
|
Al Bsharah
Aholics.com
Jeepaholics Anonymous
Broncoholics Anonymous
Network Insight
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 27 December 2002 : 13:43:41
|
| I experienced this problem last week as well. |
 |
 |
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 27 December 2002 : 14:22:42
|
| I experienced the problerm as well. Now I just see a sql statement. I think it is being tested. |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 27 December 2002 : 14:33:25
|
| I think we may have hit some sort of limit on the amount of users. This just happened within the last week or so, and nothing has changed with the members.asp file. |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 27 December 2002 : 14:36:54
|
| we currently have 4077 members who have never made a post and have not been here for over a year. If I can get an ok, those 4077 members can be removed from the database. |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 27 December 2002 : 16:23:08
|
OK.  |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 27 December 2002 : 17:28:06
|
| sounds like a good idea Richard, although the members queeries run fine if run directly in a SQL window, plus the timeout does not correspond with any of the default timeouts set for IIS or SQL, so something may be able to be done to the code to fix the problem |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 27 December 2002 : 18:48:35
|
| I tried just filtering out users that had not posted and had a M_LASTHEREDATE of more than a year ago, and the members page still timed out. I then tried using TOP 10000 (which timed out also), and then TOP 1000 (which worked, the page came up, but not as fast as it used to). |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 27 December 2002 : 18:49:54
|
| Sounds good to me. A little clean up wouldn't hurt. |
Support Snitz Forums
|
|
|
|
Jeepaholic
Average Member
USA
697 Posts |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 27 December 2002 : 20:04:52
|
| A cleanup is not a bad idea, however, knowing why it happens will be useful also. |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 27 December 2002 : 20:07:50
|
| ok, I removed all users who had 0 posts and had a M_LASTHEREDATE of more than a year ago. This was a total of 4079 users. I also ran the Update Forum Counts from the Admin options after removing those users. But, the members.asp page is still timing out. So I guess that wasn't the problem. |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 27 December 2002 : 20:23:42
|
Richard, have you tried to determine at what point it times out. Does it time out at
rs.Open or rs.GetRows or after that. |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 27 December 2002 : 20:36:00
|
it times out at this line:
maxpages = cLng(rs.pagecount)
|
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 27 December 2002 : 20:52:19
|
| Try to use the rs.recordcount and strPageSize to get the maxpages and see if it still times out. |
|
|
|
Topic |
|
Topic Locked
