Looking for a programmer who can assist with improving the performance of a wordpress based website that is performing extremely slow on the back end. We have already tried a new theme, disabled all plug ins, changes hosting providers and none of these helped improve website performance. The website is about 6000 pages and has about 6000 unique images, the hosting provider recommended having indexes created to make the tables query faster within the MySQL Please send me a pm or post questions here,
Have you created indexes? if yes then what is performance after creating indexes? Regards Younas Aamir
You need to go through all the sql queries in the code, and create indexes on fields which are used after WHERE in queries. You should also see the mysql log files and find out the slow queries
In general just on the foreign keys - not on all the fields. Usually the database will use one index to run, won't it? You can always create complex indexes but I think that may be beyond the skillset of the OP. Given that it's wordpress all the indexes should be ok Are you on shared hosting? Do any of the other sites on the server have performance issues? Probably not if you have changed hosting. Have you used Chrome/Firefox to inspect the page and see if there's any one factor causing the site to run slowly.
This is above my technical expertise We changed hosting providers to see if this may make a change, no luck Here is a list of the troubleshooting we have attempted following various posts and similar threads from wordpress.org help forum here are some of the fixes we have tried, the issues is isolated to the add or edit pages portion: we have tried disabling all plugins changing the theme changing the permalink structure verified that the php memory allocation is 256m or 512mb we ran the smushit photo optimizer to change and altar all of the image files to try and make them small added to the wp-config file this, as suggested: define('CONCATENATE_SCRIPTS', false ); uploaded several caching plugins, wpsuper cache, w3cache etc uploaded and run several database optimizers changed the file permission of the wp-content folder to 755, including recursing into sub directories None of these have made a difference
Contact Jonathan in Onlinecares. I had a high traffic wordpress site hosted with their VPS. To reduce the resource usage, Jonathan installed Nginx along with some accelerator scripts and configured mysql databases in another server. I noticed a very good difference in the website performance since then.
You need to look up articles on deleting post revisions. You can do it manually or edit the source code to do it automatically. Set the number of revisions to store in the database: either of these are good define('WP_POST_REVISIONS', false); define('WP_POST_REVISIONS', no_of_revision); PHP: Apparently unused themes carry an overhead - get rid of them Unused images do too - there's a plugin to identify them.
thanks, we are now operating better, found a hosting provider with some skilled database administrators to help us get things running smooth.