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…

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?

How to analyze HTTP Traffic to find the bottleneck?

thanks.

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…

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.

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.

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

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.

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

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…