Ive tested the problem on these forums and it seems ok so for now my problem is local to me so any diagnostic advice would be appreciated.

on my forums when i click on a user name to go to there profile page it can hang for 10seconds before displaying. At first i thought a recent server update may be causing this but its still happening after a week?

i have rebooted the server : no change
checked database tables : no errors.

if i go via the control panel and bring up a user profile make a small change and then submit that also takes a similar time, but the point being that via the admin side of things there are no custom islands that could be causing this problem.

eventually a user profile will drop in from a users point of view, or time out with page can not be displayed. its frustrating.

result from forum main page
Generated in 0.041 seconds in which 0.011 seconds were spent on a total of 9 queries. Zlib compression enabled.

results from click on a user name and the profile showing.

Generated in 20.027 seconds in which 0.006 seconds were spent on a total of 14 queries. Zlib compression enabled

any ideas?
everything else seems fine.

thanks in advance.

Generated in 20.027 seconds????
Are your sure???
That is a lot of time!
Possibly you may need to try the optimize table command.
For the user data tables.

thats a copy and paste.

optimize table command.
i can give that a go.

i only used "check tables" via phpadmin view.
as there were no errors (come back as ok) i thought that was the end.

i can try the optimize table command in the morning when the forums are quiet. so another 10hrs.

Thanks Ruben.

i do have just under 8,500 users.
i will optimize all the tables with user as a prefix.

Just a thought since you have been around since dirt.
Maybe your tables need to be cleaned a bit.

cleaned ?
ive used optimized in the past, but not seeing anything actually report back or changed presumed it was a function that i did not need to use and check tables was going to be my flag if there were any problems.


did you mean clean the tables, by optimizing ?

Yes,
Optimize can be run from the ubb control panel or such as phpadmin,
Either way it will clean up the tables much like de-fragment does for hard drives.
Since you have been around a long time with 8500 plus members possibly it may need to be cleaned up.

I myself have never seen any feedback of status of using the optimize table myself other than it was successful.

But I have seen improvement in response speed.

OK i will give that a blast in the morning.
lets hope it is that simple.

Thanks for the advice appreciated.

mark

Results from Optermizing all the Tables. OK (Up to date).

Copy and pasted result from clicking on a user name.

Generated in 20.140 seconds in which 0.027 seconds were spent on a total of 14 queries. Zlib compression enabled.
Powered by UBB.threads™ 7.5.6p2


Even though is says 20 seconds its not that long its more like 6 - 10 Seconds.

The User List page via the main forum is instant.

Via the Admin Side Updating a user it seems to have come good, that's instant again. So now i have to look at my custom islands i think. There must be something on the profile page that's causing the delay.

Give me until next week and i should come back with some results.
Finding the time to poke about hummmm.

Ok ive just tried turning off the side islands and there is no difference.

The one thing constant is this.
Generated in 20.037 seconds in which 0.010 seconds were spent on a total of 14 queries. Zlib compression enabled

9 times out of 10 its always reads "20" seconds, but its more like 6 - 10 seconds really.

I need to run repair on the tables to see if that helps.
I'm not prompted for a repair but lets see if that helps.
I also turned of comments in the user profile options with no change.

Next test will be a few days as i go visiting family.

no solution found.
its pretty constant at reporting back 20second but in reality its less than 10.

if as admin from the main forum select edit user from the drop list alongside a post its instant.

if i want to view a there profile page on the forum it has that delay.

i noticed that when i was using the open /close forum option the admin screens seem to be taking a similar time to save and rotate back.

ive more time in a week to dig a bit deeper.

will update this post as and when.