TinyPortal

Dear TP

I sort of have a problem with my forum, everything seems to be working really great however, the problem I am having is that when you go to read members postings, it takes a very long time for the page to come up and load, way too long. I have been to other sites, and it works great, but in my own forum it just takes too long for anyone to read someone’s post or replies.

I have done everything possible on this end, optimized the tables and so on, and it still doesn’t seem to work that fast, and my members are starting to complain.  :tickedoff: :tickedoff: :tickedoff: :tickedoff: :tickedoff:

Any suggestions?

Its not your fault.  I suspect that the SQL server that is being called on to populate threads is dog-doo-doo

Change your host maybe?  Try: www.Outpost-Host.us





shameless plug :P  But serisouly, it is prolly the host.

It can also be be things like custom blocks that have some code in them that can slow down the site. Could be throwing php into and endless loop or something. Could be the server too. I would contact your host and have them look into it.

hadnt thought of that, but then again... I wasnt thinking >_<

Of course, I would try disabling the blocks first to see if they are causing this. :)

You might, but stigmartyr would be switching to a host in some outpost way out there.....   ;D

Quote from: TwÃÆ'Ã,­nsX2DÃÆ'Ã,Â¥Ã,,‘ÂÃ,³ on April 07, 2006, 05:41:03 AM
You might, but stigmartyr would be switching to a host in some outpost way out there.....   ;D

On the frontier of technology...to boldly go where no man has gone b4 and all that jazz.

Well, I really don't know about my host how it would have anything to do with why it would run slow, like I said, everything else works very well, just when you want to read someones post, that is when it slows way down, I have a good host, and never had any problem before, but I will call and let them know about the problem.

Thanks

Ichbin is right if ur scriptz are bloated or missing lines to close them they will tail spin and lag ur board. 

If its only when opening messages, I suspect that the SQL server is responding slowly.  Hence ur host could be the problem.

Quote from: stigmartyr on April 07, 2006, 06:48:45 AMI suspect that the SQL server is responding slowly.

And what causes this 99% of the time? Insufficient RAM, a finite resource.

My guess is that the conversion from PhP Nuke didnt apply like it should have done. it's only from within the forums posting it's slow, It did the exact same thing before tp and blocks to.

Running the forums takes a lot more SQL resources - this is why he is running slow.

If the conversion went south, he'd not have a functioning board right now.

It does the same from a clean testinstall 1.0.7/tp v0.86 to Everything accept the forum works good, the forum is loading very slow

Maybe there is something wrong with 1.0.7?

I just got a message from my host, he told me that it isn't the server, that is fine, he sort of agrees with G6 on this, the change over might be causing some conflict. Um, and about the Ram? Are you taling on my computer or the sever? lol

the server your webpage is hosted on  ;)

I think after a long time loading, the site need maintenance for check and repair the error, however u can using the optimize feature in the SMF admin section to opt the SQL tables and so made your site faster

To do it, in admin section, go to Maintenance --> Forum Maintenance and apply each item in this section for your forum, hope it will OK to help you Ã, :)

QuoteI think after a long time loading, the site need maintenance for check and repair the error, however u can using the optimize feature in the SMF admin section to opt the SQL tables and so made your site faster

Everything is thought of allready, and i have done all those things in his forum, so the basic things are done already Elvpn

Thank G6
So you can check your SQL servers (and do not forget make a compare them too)
In most case the SQL server is an important factor :)

Can we get a link to your site please?

http://parentingdiscussions.com/smf/index.php

Can you enable "show page load time", so I can see what it says?

Done, and the fastest load time i got after open 10 diffrent forum replyes were this

Page created in 20.884 seconds with 29 queries.

Quote from: Xarcell on April 07, 2006, 03:33:58 PM
Can we get a link to your site please?

Sure www.parentingdiscussions.com

Do you have anything in your error log? I noticed the same delay when viewing only posts.

Nothing that generate from posting, read posts, post a reply

This error generates from when you enter the article section

  http://parentingdiscussions.com/smf/index.php?action=tpadmin;sa=articles
8: Undefined index: theme_version
File: /home/parentin/public_html/smf/Sources/TPortalAdmin.php
Line: 62

And this when entering the Block section

http://parentingdiscussions.com/smf/index.php?action=tpadmin;sa=blocks
8: Undefined index: submissions
File: /home/parentin/public_html/smf/Themes/default/Admin.template.php (eval?)
Line: 28

But no slow loadtime there

The only thing I can think is that is a database issue. Weither its a corrupt table or server issue it's hard to say. What is causing it? I don't know...

He have converted the whole thing from an old NUKE setup.
His host are looking at the tables in the database as we speak, he to think it have something to do with that the old nuke db causes the slowness.

And now we know why NUKE can go and suck and egg.  :o

I really thought that the nightmare of nuke was over with, and it just keeps coming back and bitting me in the rump, I am so sick of nuke I have delete it from all my favorites and banned myself from their sites. OH lord why didn't I listen?

(https://www.tinyportal.net/proxy.php?request=http%3A%2F%2Fimg.photobucket.com%2Falbums%2Fv248%2FRobertseyes%2Fpeeonnuke.jpg&hash=624f579e41530bd47b131017c7ea11b099341959)

:2funny:

Quote from: Robert on April 07, 2006, 07:03:41 PM
(https://www.tinyportal.net/proxy.php?request=http%3A%2F%2Fimg.photobucket.com%2Falbums%2Fv248%2FRobertseyes%2Fpeeonnuke.jpg&hash=624f579e41530bd47b131017c7ea11b099341959)

:2funny:

Agreed.   ;D

Have you tried indexing your tables?

QuoteHave you tried indexing your tables?

Tutorial please Twins :)

Whats that, and how to do it ?  :o

Maybe something to try would be to create a new database. Then export each table one by one and put them in the new database one by one. Then you can see which Table is causing it, if it is...

Indexing the fields in your database is a simple task, if you have phpMyAdmin, but could be a little time consuming. It is done much quicker from command line, but the minute I try to describe that function here, someone will crash their database - plus most don't have command line access.

Open phpMyAdmin and select your database.

Then open each table (view structure). Select the fields desired (or select all) and choose the index function.

Pretty simple operation and it can speed up your database as well as make optimization more efficient. It can increase your DB size, though - so if you're pressed for disk space, you might think twice before a wholesale indexing operation.

Start with the boards table.

QuoteOpen phpMyAdmin and select your database.

Then open each table (view structure). Select the fields desired (or select all) and choose the index function.

Pretty simple operation and it can speed up your database as well as make optimization more efficient.

Thanks Twins, will take a go at it right now and see it there is any emprovement.

If I remember correctly, you will need to make some modifications to some tables. A serious flaw in SMF is it doesn't always create, handle or update tables correctly or completely.

Quote from: IchBinÃ,â,,¢ on April 07, 2006, 08:45:21 PM
Maybe something to try would be to create a new database. Then export each table one by one and put them in the new database one by one. Then you can see which Table is causing it, if it is...

OMGz :O  I would rather 'DELETE' and start all over than waste my life scanning thru SQL tables .. and desperately fighting them to work right hehehe.  That is unless Im billing by the hour. ;)

It is going to work one way or the other!!!

QuoteOMGz :O  I would rather 'DELETE' and start all over than waste my life scanning thru SQL tables .. and desperately fighting them to work right hehehe.  That is unless Im billing by the hour.

I think of it like this...

Twins gave a thought of how to maby find the error and see if it help.

I try it out, see what comes from it, maby it does get better, maby it dont, but in the process, even if it is a bit boring, i learn something from it :)
So it aint all that bad to atleast try the diffrent ways for fixing things, especially if there comes a good idea on a way to perhaps solve the problem ;) 

You have a point.  I've wasted weeks of my life fighting broken SQL tables. The exhilaration of victory is uplifting, when u do find a solution.

Quote from: stigmartyr on April 07, 2006, 10:28:04 PMI've wasted weeks of my life fighting broken SQL tables. The exhilaration of victory is uplifting

You're a student of either creative writing or drama, aren't you?   ;D

EDIT: Please stay with the Topic ;) .