Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Speeding up load time
Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jun 27, 2015 - 3:24 pm

we will be here... 😉

Avatar
Stan Dahl
Member
sp_UserOfflineSmall Offline
Oct 8, 2015 - 2:23 pm

Wanted to chime back in on this thread for a moment in case anyone else is dealing with slow load time in the forum. 

The thing that finally did the trick for us was disabling our security plugin (iThemes) and getting a firewall from sucuri.net ($10/month). We tried most of the major security plugins and they all slowed down our load time and gave us errors on occasion.  For sites that have a lot of plugins, it's worth looking at their firewall.

The forum has been zooming ever since...

Avatar
Ike
Sawtry, UK
Member
Free Members
sp_UserOfflineSmall Offline
Oct 8, 2015 - 3:07 pm

Thanks for the contribution, some security plugins can definitely do a number on load times..

Avatar
Alex T
Member
sp_UserOfflineSmall Offline
Oct 26, 2015 - 11:24 am

Yellow Swordfish said
Oddly - we wrote the small plugin to help a user - decided to offer it and then promptly forgot about it! This was about a year back. It IS going to make an appearance in a few weeks when we rework the website here.
Not swapping the database engine is really not hard. It can be done manually in phpMyAdmin at table level. It was just the two tables referred to that had indexing unsupported by innoDB. I have attached a copy of the plugin you can try. Running it multiple times has no ill-effect although it should just do the job on the first pass. It is a WP plugin and adds an item to the forum menu. When done it should just be deactivated and removed. The plugin is a bit utilitarian by the way - nothing fancy!

Make a backup first? Always 🙂

How does this plugin work?  Does it make the table change for you?

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Oct 26, 2015 - 11:38 am

Firstly it is a WordPress (NOT Simple:Press) plugin and when activated will add a new item at the bottom of the SP Forum admin menu.

If you have the latest version it will ask you whether you want the whole site or just the SP tables converting and then - when you press the 'go' button it will do the conversion for you, It only takes a few seconds,

There may be some conditions where the action id disallowed bit we have not encountered one yet. Also - if any of the tables from plugins have anything defined that is innoDB incompatible then it will leave that table alone.

make a safety backup and give it a try!

andy-signature.png
YELLOW
SWORDFISH
Avatar
Alex T
Member
sp_UserOfflineSmall Offline
Oct 26, 2015 - 11:40 am

Yellow Swordfish said
Firstly it is a WordPress (NOT Simple:Press) plugin and when activated will add a new item at the bottom of the SP Forum admin menu.

If you have the latest version it will ask you whether you want the whole site or just the SP tables converting and then - when you press the 'go' button it will do the conversion for you, It only takes a few seconds,

There may be some conditions where the action id disallowed bit we have not encountered one yet. Also - if any of the tables from plugins have anything defined that is innoDB incompatible then it will leave that table alone.

make a safety backup and give it a try!

Yea, I installed it in WP but haven't activated it yet.  Wanted to know how it functions first.  

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 26, 2015 - 9:14 pm

just a db conversion...  potential throughput benefits...

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17361
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625