| Author |
 Topic  |
|
masterao
Senior Member
Sweden
1678 Posts |
 Posted - 01 March 2005 : 14:36:07
|
| I was able to view Huw's profile, but it took 126.27 seconds to load. I tried to view Podge's Profile but got a timeout. I could see his contact info (email and yahoo im) and the topics he had posted in, but nothing else. Ruirib's profile loaded in 81.2 seconds and my own profile loaded in 45.19 seconds. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
 |
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 01 March 2005 : 15:01:49
|
ruirib's: 81.17 seconds
huwr's: 81.16 seconds
OWM's: 16.21 seconds |
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 02 March 2005 : 00:14:22
|
huw's profile...
This page was generated in 90.28 seconds.
ruirib profile...
This page was generated in 54.17 seconds.
Huw you can send me a message if you need me to help you run any other test's. One thing I would try is have it output the page generation times before and after each query on for a given member's id.
If MemberID=756 Then
Response.Write "Starting to run query XX at " & pageloadtime & "<br>"
End If
' # RUN QUERY HERE
If MemberID=756 Then
Response.Write "Finished running query XX at " & pageloadtime & "<br>"
End If
This way maybe could figure out what part of the page is taking the longest. |
Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets |
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 02 March 2005 : 07:13:56
|
Shaggy
This page was generated in 76.77 seconds.
Podge
Partial load then Timeout - Timeout msg in "recent topics"
HuwR
This page was generated in 90.11 seconds.
Withanhdammit
Partial load then Timeout - Timeout msg in "recent topics"
masterao
This page was generated in 49.67 seconds.
tribaliztic
This page was generated in 22.62 seconds.
redbrad0
This page was generated in 54.14 seconds.
Podge - Again
Partial load then Timeout - Timeout msg in "recent topics"
withanhdammit - Again
Partial load and timeout - Timeout msg in "recent topics" |
_-/Cripto9t\-_ |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 02 March 2005 : 08:18:47
|
After Cripto's post, I tried a few more and they all seem to be timing out on recent topics, co I tried this member who has no posts and it loaded up in 0.11 seconds.
|
 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.” |
Edited by - Shaggy on 02 March 2005 09:28:46 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 02 March 2005 : 08:46:54
|
quote:
Originally posted by Shaggy
After Cripto's post, I tried a few more and they all seem to be timing out on recent topics, co I tried pop_profile.asp?mode=display&id=24004this member[/profile] who has no posts and it loaded up in 0.11 seconds.
yes, this was also the direction I was looking, will run the recent topics querry through the profiler see if we need to add an index or anything. |
|
|
|
Jorrit787
Average Member
Netherlands
681 Posts |
Posted - 02 March 2005 : 13:36:45
|
It's not just the profiles for me, the whole forum has been really slow over the past few days. I have been waiting 14.32 seconds for this Reply To Topic page to appear.
Maybe the database and/or server is getting overloaded? |
eXtremeGossip  |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 02 March 2005 : 13:48:01
|
No on both counts, the database server is hardly even crawling let alone overloaded, and that wouldn't explain why I can view the profiles in under 0.2 secs, it has to be a dodgy query somewhere.
The web server isn't particularly great, but is in no way overloaded, it is only running half a dozen sites, none of which are even remotely busy. I would move it to a newer faster server but do not have control of the DNS. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 02 March 2005 : 13:49:14
|
No one uses reply to topic! Real Snitzers use quick reply!   .
Just kidding. Just tested reply to topic and took about 5 seconds. Posting from quick reply is much faster. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Jorrit787
Average Member
Netherlands
681 Posts |
Posted - 02 March 2005 : 14:12:39
|
Just tried some profiles:
ruirib - 72.2
RichardKinser - 22.69
HuwR - 108.2
Davio - Timed out
OneWayMule - 13.66
@tomic - .22
crash - .48
Seems like the problem is mainly with Admin/Moderator profiles...
Oh, and another thing: A few hours ago I received a 'No website registered at this address' error. It lasted for a few hours and then I could get on again  |
eXtremeGossip |
Edited by - Jorrit787 on 02 March 2005 14:16:07 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 03 March 2005 : 09:56:33
|
Ok, well it isn't the sql queeries, they are executing very quickly on the SQL box, so will do as brad suggested and add some timers to the profile page to see where the hold up is.
I will make a post here when I have done it (probably the weekend) so some of you can test it out. |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 03 March 2005 : 10:20:13
|
Looking at the profiles that Jorrit posted, could it be related to the last post time? The longer ago the last post was, the faster the profiles seem to be loading.
Tried it meself and profiles for people who haven't posted in the years are loading normally with the load time going up as the last post date does.
|
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.” |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 03 March 2005 : 16:15:48
|
Just had a look myself and the following was achived:
Users who have been on in the last 12 months:
PeeWee.Inc: 27.14 seconds
Shaggy: 94.81 seconds (this was after his profile did not load fully)
RichardKinser: 18.14 seconds
Rasco: 0.14 seconds
Reinsnitz: 4.67 seconds
@tomic: 0.12 seconds
Users who have not been on for over 12 months:
Freeman II: 0.14 seconds
freddydoes: 8 seconds
fatwillie: 6.98 seconds
Funkyfin2000: 0.09 seconds
Fulgan: 0.12 seconds
fsscreenshots: 0.16 seconds
Really there is not consistancy in it at all. It appears to me to be a network issue more than anything as I viewed the profile of each group at the same time and they where pretty much consistant except for 3 of them who where viewed 1 after the other.. |
Cheers,
David Greening |
|
|
|
Topic |
|
Topic Locked
