Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (Gizmo, Dunny), 23 Guests and 3 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/23/06
Posts: 842
Top Posters (30 Days)
Ruben 45
Bert 26
Gizmo 17
Rob Provencher 10
Rimex 9
sw55 7
SD 7
Eugene 5
Matthias1976 4
Dunny 3
Latest Photos
Uhm...
Mayan End of World
Gas Station Disco Video Shoot
Test Pictures
Audrey Kate
Page 1 of 2 1 2 >
Topic Options
#249926 - 08/22/12 02:50 PM profile view : Generated in 20 seconds ?
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4480
Loc: Liverpool : England : UK
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.
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#249927 - 08/22/12 02:58 PM Re: profile view : Generated in 20 seconds ? [Re: Mark S]
Ruben Offline

Registered: 12/20/03
Posts: 4932
Loc: Lutz,FL
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.
_________________________
Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Top
#249928 - 08/22/12 03:07 PM Re: profile view : Generated in 20 seconds ? [Re: Mark S]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4480
Loc: Liverpool : England : UK
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.
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#249929 - 08/22/12 03:11 PM Re: profile view : Generated in 20 seconds ? [Re: Mark S]
Ruben Offline

Registered: 12/20/03
Posts: 4932
Loc: Lutz,FL
Just a thought since you have been around since dirt.
Maybe your tables need to be cleaned a bit.
_________________________
Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Top
#249930 - 08/22/12 03:58 PM Re: profile view : Generated in 20 seconds ? [Re: Mark S]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4480
Loc: Liverpool : England : UK
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 ?
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#249931 - 08/22/12 04:09 PM Re: profile view : Generated in 20 seconds ? [Re: Mark S]
Ruben Offline

Registered: 12/20/03
Posts: 4932
Loc: Lutz,FL
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.
_________________________
Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Top
#249932 - 08/22/12 04:14 PM Re: profile view : Generated in 20 seconds ? [Re: Mark S]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4480
Loc: Liverpool : England : UK
OK i will give that a blast in the morning.
lets hope it is that simple.

Thanks for the advice appreciated.

mark
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#249935 - 08/23/12 01:48 AM Re: profile view : Generated in 20 seconds ? [Re: Mark S]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4480
Loc: Liverpool : England : UK
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.
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#249938 - 08/23/12 01:29 PM Re: profile view : Generated in 20 seconds ? [Re: Mark S]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4480
Loc: Liverpool : England : UK
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.
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#250030 - 08/29/12 11:26 AM Re: profile view : Generated in 20 seconds ? [Re: Mark S]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4480
Loc: Liverpool : England : UK
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.
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
Page 1 of 2 1 2 >



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Time zone setup
by skicomau
Today at 12:16 AM
Express hosting.
by Ruben
05/16/13 03:54 PM
Level of detail in new user registration emails
by Mitch P.
05/15/13 10:20 PM
Approving users
by Bert
05/15/13 09:22 PM
Users randomly added to other group
by Bert
05/15/13 09:15 PM
Forum Stats
10966 Members
36 Forums
33958 Topics
183407 Posts

Max Online: 978 @ 06/24/07 10:19 PM
Random Image