Extreme Slowness after SMF 2.0 Upgrade, and WYSIWYG Suggestion

[reanimationxp]

Hey guys,

Still somewhat new to SMF, but recently upgraded my forum to 2.0 mostly for WYSIWYG support, and I have two complaints.

First off, is anyone else noticing EXTREME slowdown after upgrading? Certain pages, i.e. visiting the form's index for the first time (logged out), viewing my profile after logging in, etc. are taking upwards of 20 or 30 seconds to generate the page, with 10 or so queries. SMF has never been extremely fast in my book when compared to something like PunBB, but it was never this bad. I've also noticed the issue when first visiting the forums here, without logging in. Took 26 seconds to build the community index prior to logging in.

Is anyone else noticing this? If so, did you do an upgrade or a clean install?

Second issue, why is there not an option to default all users to WYSIWYG mode? What good is a rich text editor if my users can't see it by default, or I can't perform a bulk action to enable it on all their profiles?

Thanks for any help guys, and great product either way.
-Andrew

[Assistance]

Configuration> Current Theme > Member Options >
Change current options for all members using this theme =

Show WYSIWYG editor on post page by default?

Second issue, why is there not an option to default all users to WYSIWYG mode? What good is a rich text editor if my users can't see it by default, or I can't perform a bulk action to enable it on all their profiles?

[reanimationxp]

Well that solves the second half.. wish that wasn't so hidden Thanks!

[metallica48423]

can you please download the status.php tool from downloads > tools, upload it, and link us to it?

How many people are usually online at any given time?  etc.  what is the board activity like?

My board has absolutely no load time issues at the moment.

Our long page loads are due to different circumstances.  For example, when we sent out the 130,000 emails that 2.0 public was out

[reanimationxp]

it's only upon visiting certain pages for the first time though is my confusion, and i don't have any type of caching enabled.

there are currently only about 30 users, with an average of 1 online max at any given time. (it's still being developed)

[winrules]

Try enabling level 1 caching. Some things that used to be cached in the settings table regardles of the caching level were moved to the cache in 2.0.

[reanimationxp]

http://www.bsuakpsi.org/forum/status.php

and for the record most pages are working ok except the ones i mentioned.. here is the report from clicking Profile once logged in.

Page created in 28.153 seconds with 9 queries.

[reanimationxp]

I enabled level 1 caching, then went to the profile page (which took about 24secs to load), and on subsequent visits, the time has been around this, with a couple less queries:

Page created in 0.106 seconds with 8 queries.

This may have fixed the problem I will continue to monitor the speed and let you guys know should it start again.

Thank you to Assitance and winrules for the suggestions!

[reanimationxp]

Alright guys, unfortunately that didn't work. After being away from the site for a day or so then coming back, I still get this when accessing profile for the first time after logging in:

Page created in 32.214 seconds with 8 queries.

Again, this only started after the upgrade to 2.0.. everything was instantaneous before. I even tried optimizing the databases. See the status page I posted above if you need more server info.

[Grudge]

2.0 shouldn't be any slower than 1.1 out of the box. I wonder if somehow your indexes have got messed up in the upgrade.

Could you please turn on slow query logging on MySQL to see what is causing the problem. Alternatively if you can get the slow page loading to happen easily simply load the forum page and whilst it's loading refresh status.php and look at what queries are taking > 5 seconds and post them here.

There is no reason whatsoever that you should have those slow problems - all other installs I know of are fast.

Thanks,

Grudge

[Tristan Perry]

Are you on a shared host?

Either way, your server seems quite overloaded at the moment. When I checked the status.php page, the server is using up almost all of the 4 gigs of memory allocated to you. Plus server loads are continually above 1.

Surely this is the cause of this?

[reanimationxp]

yes, i'm on a shared host and those server stats do loook high. i checked my cpanel and the memory usage there is far lower than what PHP is reporting. anyhow, i'll give them a call today and see if they can check on the box.

http://www.aldencs.com/dump/public/akpsi/status.jpg

above is a screencap of the server status WHILE the 28sec profile is loading. hopefully that's what you wanted i don't see any sql 'jobs' other than the number of running processes, so i'm not sure what exactly you're looking for on there.

[metallica48423]

I don't think the bottleneck here is the mysql queries, but rather the webserver being overloaded

[reanimationxp]

i would tend to agree and called them about it.. they reduced some of the memory usage at the time but server overload doesn't explain why it only happens on certain pages and i can make it happen. if it were infact overload any queries at all should cause the problem, and consistently. it's definately something that, once cached, goes a lot quicker. and it's obviously caching on the server side.

[reanimationxp]

i've narrowed it down to the profile summary and a couple other pages that cause it. turning on level 1 caching definately makes an immediate difference. 28 seconds load time drops to less than half a second on an immediate subseqent visit.

however even with caching enabled, it still takes 28sec if i wait a day or so and click profile again, even if i'm still logged in via cookie. (presumably after the cache has cleared itself).

i can also make it happen consistently if i disable caching, or clear the forum's cache manually then visit profile again.

[Ol' Wombat]

Hey guys,
Still somewhat new to SMF, but recently upgraded my forum to 2.0 mostly for WYSIWYG support, and I have two complaints.

First off, is anyone else noticing EXTREME slowdown after upgrading? .....

Thanks for any help guys, and great product either way.
-Andrew

Yes, I too had a noticeable slowdown, not as bad as yours, after the upgrade (not for the first time) - the usual way out for me was a clean full install of the new forum and re-importing the database saved *after* the upgrade. Now forum speed is fine again.

[reanimationxp]

interesting idea.. never thought of that may give that a try.. thanks!