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
Fast Loading Time, But Very Slow When Add New Topic or Reply Post
Avatar
Sukarto Sudjono
Member
Free Members
sp_UserOfflineSmall Offline
Aug 14, 2014 - 12:29 am

Hi,

I just launch my simple press forum, migrate from Mingle. I found out that the loading time is fast. We don't have any problem, but when I add a new topic or reply to a post, we got very slow response, need almost 10-12 seconds in average for simplepress to complete the process.

We still just have around 5000 posts with 383 members. What do you suggest to improve the speed in posting a new topic or reply post? 

I just activate several plugin (see below/attachment).

Screen-Shot-2014-08-14-at-11.27.45.pngImage Enlarger

 

Thank you

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Aug 14, 2014 - 1:17 am

what kind of hosting is this?   how much php memory is allocated?

might try optimizing your db and see if that helps... 

might be worth analyzing the http traffic and see what the bottleneck is...

Avatar
Sukarto Sudjono
Member
Free Members
sp_UserOfflineSmall Offline
Aug 14, 2014 - 1:26 am

It is at Shared Hosting Turbo (highest plan) at Site5.

I see in SimplePress, Toolbox menu and environment, the PHP Memory is 256 MB. Is it enough?

Simple:Press   Version: 5.5.0.1
Build: 11488
Release: Release
WordPress   Version: 3.9.2
Language: en-US
Character Set: UTF-8
Theme: Dynamik-Gen
PHP   Version: 5.3.28
Memory: 256M
Max Upload: 128M
Timeout: 300
MySQL   Version: 5.1.67
Prefix: wp_

How to analyze HTTP Traffic to find the bottleneck?

thanks.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Aug 14, 2014 - 1:28 am

yes, 256M is plenty...  I occasionally test simple press with 32M though I would recommend more...  quite an old version of mysql...  did you try optimizing the db?

to monitor http traffic you would need a browser addon... for FF, its something like httpfox or other things that can work with firebug...

Avatar
Sukarto Sudjono
Member
Free Members
sp_UserOfflineSmall Offline
Aug 14, 2014 - 1:31 am

Ok PHP memory is enough.

How to optimize DB? Do you mean do it from PhpMyAdmin or from SimplePress Toolbox?

Please give some guidance and let me try which one can improve the performance.

thanks.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 14, 2014 - 3:55 am

Shared hosting of any sort is still shared hosting. While it may be 'premium' in some way and things may load well there is still contention  and potential bottlenecks for database server access. Posting to the forum is quite a complex affair as far as accessing the database goes and of there are many other websites on the shared server all performing their own DB activity it can be a source of slowdown.

Optimising your database tables is really something that should be done regularly and if not done can lead to a slow down in performance and after a while, corruptions. You can optimise from within phoMyAdmin but I always suggest that installing a WP plugin like 'WP Database Manager' where you can schedule automatic and regular optimisations (and even backups) is worth doing.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Sukarto Sudjono
Member
Free Members
sp_UserOfflineSmall Offline
Aug 14, 2014 - 8:44 am

So basically you recomend use VPS for Simple Press with my forum size right now? 

What do you suggest about VPS memory, cpu etc ?

thx

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 14, 2014 - 9:39 am

What you have now is probably fine - but I wasn't necessarily suggesting you change to a VPS although, of course, a VPS should give you better performance. There are always a lot of factors to take into consideration - especially how busy your forum is for example.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Azti
Member
Free Members
sp_UserOfflineSmall Offline
Sep 26, 2014 - 12:56 am

Running the following from the command line on my server resulted in a PROFOUND improvement in performance for both displaying, and creating, a post:

mysqlcheck -o -u root -ppassword db_name

I went form 12+ seconds to load to now 4 to 5...

I suspect that this is what is being run by PHPMyadmin as well as any WP Plugin db optimizer...

--Azti

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Sep 26, 2014 - 2:30 am

scheduled, periodic db optimization and checking is always strongly recommended for any mysql set up...  use a wp plugin for this or a standard Linux cron job to automate it...

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