Board loads slow

[itsjustme]

Hi,

Http://wannafindit.com/forum/index.php

The boards "stores" and "hot deals" loads real slow, other boards load fast.

I just moved to Charlottezweb.  The problem ws there at godaddy also.

running 1.05

[Ben_S]

http://www.simplemachines.org/community/index.php?topic=49999.0

[itsjustme]

ok,

avatar not checked, not very many posts as I am just setting this up.

It's only those two boards.

[itsjustme]

only weird thing I see is

collation_connection:     latin1_swedish_ci
collation_database:    latin1_swedish_ci
collation_server:    latin1_swedish_ci

Don't know why it's swedish..

[itsjustme]

This board does not have a lot of posts...221 total.

my other smf install has over 100,000 posts, and I generally don't have this particular problem.

Moving to Charlottezweb has improved the overall speed, it's just a problem with these two boards.

I have run repair and optimize in phpmyadmin.

Are there any ideas?

[H]

Charlottezweb host a lot of SMF boards and most have received good feedback. Maybe you should try posting your problems at charlottezweb

http://forums.charlottezweb.com/

[charlottezweb]

The problem appears to be with the server connection settings.  From the looks of it, his forum on my server was connecting offsite to his old host's db and not the one he relocated to Charlottezweb.

We should know if this solves it shortly. 

Regards,
Jason

[charlottezweb]

Ok, I may need some SMF Dev support on this one.

I haven't gone through the files manually yet, but his server settings have been corrected and he said he removed the db from the old host entirely.  So we should be able to rule those two things out now.

However, his forum is *definitely* lagging (sometimes more than 30+ seconds) and ONLY for the two boards he mentioned above.  The other boards and pages are zipping along fine.  I've never seen this sort of situation, but it is confined to only 2 out of his 6 or so boards.

Any further advice?

TIA,
Jason

[Fizzy]

Have you tried repairs in both mysql and the forum admin centre?

[itsjustme]

Have you tried repairs in both mysql and the forum admin centre?

I did it, and Jason did it, it the edit server settings page.

Then I...


went to phpmyadmin
selected the database
selected structure
checked all
with the "with selected" check box I selected repair, then check, then optimize

Dave

[Fizzy]

I sort of guessed that you would have done that, I was just checking the basics.

Have you tried copying the threads to a new board and then deleting the old one? I'm just trying to establish if there is a problem with the board or the contents (threads)
If the new board lags too then it might be content, if the new one doesn't then it would be down to an error with the old board

[Ben_S]

Add

$db_show_debug = true;


To Settings.php and see if it shows where the s lowdown is when logged in as an admin.

[itsjustme]

I sort of guessed that you would have done that, Smiley I was just checking the basics.

I was just making sure I did it right.

Add

$db_show_debug = true;


To Settings.php and see if it shows where the s lowdown is when logged in as an admin.

where do I add it?
Thanks,

Dave

[itsjustme]

Ok added it.

looking at it now

[charlottezweb]

Is that just supposed to show the db queries?

If so, they don't even add up.

I saw one that said page created in 33 seconds with 13 queries.  Then when you view the queries below and add them up, they don't come close to even half of a second.

[charlottezweb]

Also, I created a new test board and moved one of the topics from one of the slow boards to it...that one is slow as well.

But after I moved the topic out and the test board was empty, it was running fast again.

Is there a problem as suggested with the posts in those boards?  It would seem strange because the post I moved was a thread with only 1 post and the post was less than 50 characters with no images.  Just a paragraph and a link.

[Fizzy]

Ok, so if the content is at fault, what are the chances that there is a special character in one of the thread titles that is causing it to go so slowly?

[Fizzy]

My next step would be to go through each of the thread titles and re-type them excluding any possible dodgy characters.

[charlottezweb]

Ok, so if the content is at fault, what are the chances that there is a special character in one of the thread titles that is causing it to go so slowly?

As in an ascii-like special character, or normal shifted-numerical characters?  There are certainly normal ones like that -- as for ascii ones, I can't tell.

Though he is running 1.0.5...and I'm running php 4.4.1

Does he need to run that patch or upgrade to rc1 to resolve?

[Fizzy]

Have you tried migrating the threads from the old to the new board?

[charlottezweb]

Have you tried migrating the threads from the old to the new board?

Depends on what you mean by that.  I did manually move one thread from one of the slow boards to a brand new board and it did the same thing as I described above...

[Ben_S]

Is that just supposed to show the db queries?

If so, they don't even add up.

I saw one that said page created in 33 seconds with 13 queries.  Then when you view the queries below and add them up, they don't come close to even half of a second.

That shows it's not database related then, any of the topics have a lot of bbc code in? I'd suggest trying upgrading it to 1.1 RC1 which has a rewritten bbc parser.

[charlottezweb]

  I just suggested 1.1 rc 1 to him not less than 3 minutes ago.

I think that's our next step.  Thanks

[Killer Possum]

It wouldn't be the BBC code though would it? It's slow accessing the board as well, not just the post itself?

[Ben_S]

There is some degree of bbc processing done on the boardindex for some reason IIR.

[itsjustme]

upgrade to rc1 complete...still slow on those two boards

[itsjustme]

Ok, rechecked both boards, they are still slow loading, no change.

On the home page, I use ssi's, to list 25 or more of the topics on those two boards.  The home page loads fast, no delay getting them in.

When you click on one of the links produced by the ssi's, it goes straight to the board, no delay.  (both stores and hot deals)

But if you go to the forum index, then click on either of those two boards, that's where the delay is.

Dave

[Killer Possum]

OK, I got it working fast now... one board so far anyways.

What's going on is, for some reason, when itsjustme posted all those links using HTML it slowed the boards down. Now, when I switched it all to BBC code, it's blazing fast again.

Is there a reason why it's having trouble with HTML?

[Joshua Dickerson]

This is a little odd. It is just that one board - Stores. Now to figure out what is wrong with it. It does load part of the message in the messageindex. You said that you removed the HTML from the other board, right? So what happens if you move certain topics out of that board - maybe we can figure out which topic is causing it to figure out what is causing that. I would look at the code itself, but I am not on my computer right now.

[Killer Possum]

It actually seems to be all the boards containing HTML. See, I cleaned the first 10 topics and it went fast, however, if you went to the second page of topics (which at the time still had HTML, looks like they are edited now) it would be slow.

[Joshua Dickerson]

I assume you mean all of the topics containing HTML.

I am guessing what is happening is that the part of messagindex.php where it grabs the first 128 characters from the first and last message in the topic, it is getting caught in a loop because of parse_bbc wanting to 'fix' the HTML. I might be wrong. On the other hand, it could be the fact that it does strip_tags after doing parse_bbc... I have to delve more deeply in to this.

[Killer Possum]

Err... yeah sorry, it's late

[itsjustme]

I am going through and changing all to bbc. That is why some of the stores pages are going fast.  I can leave one page worth, or create another board to keep some copies in if we want to keep for reference.

[Ride]

I have this same problem with one of my boards.  Everything else loads super fast.  It takes on average 25 seconds to load!

[Ride]

ok, all I had to do was uncheck "enable basic html in posts" and BAM!  Fixed!!  Went from 25 second query to 0.11 seconds.

[Joshua Dickerson]

ok, all I had to do was uncheck "enable basic html in posts" and BAM!  Fixed!!  Went from 25 second query to 0.11 seconds.

hmm.. this is a common problem I have been seeing. Going to report it as a bug

[Ride]

ok, all I had to do was uncheck "enable basic html in posts" and BAM!  Fixed!!  Went from 25 second query to 0.11 seconds.

hmm.. this is a common problem I have been seeing. Going to report it as a bug

I'm using 1.05 by the way.