1

I read a lot about my problem. I have 4 years old Wordpress (with newest 3.8.1 Wordpress) site. And last months it become really slow. It takes about 3-5seconds to render page. In administration area is situtation more critical, there is 6-8seconds render time. MySQL queries are only 41 (when I disable all plugins) a it takes same time. But in frontend there is significant time reduction when I disable all plugins, but I want to use them. But there is almost no diffrence between 400+ queries (plugins on) and 60queries (plugins off). I use WP SUper Cache, which server pages really fast. But I want to debug my wordpress to see where exactly is the problem. I know that it might be a lot queries, but PHP works same time with 400queries and 60queries. So there must be some PHP bug, or something wrong.

I would like to have option to see what is taking so long to PHP, when it process all queries. Queries time is under 1second everytime with any amount of queries.


UPDATE: Ok, I got an idea. Because I am not a well skilled in MySQL or PHP I can share Debug Objects querry list. Is that good idea, to help me sort out this problem?

4 Answers 4

2

You can use the plugin Debug Objects and his query function to identify the slowest queries from core and plugins. I see very often the problem on a plugin or theme functionality. Identify and solve.

3
  • That is one interesting plugin, thanks for providing it for free.
    – Christine Cooper
    Feb 25, 2014 at 23:15
  • Thanks, I already use this excellent plugin. Which helped me to discover how many queries are called in each page load. But again, I don't think that queries are problem. And I can see only query call/load time. Not a PHP process query time, which is important.
    – usrbowe
    Feb 25, 2014 at 23:26
  • Thanks for the feedback. Currently I write only on a new version of hook output, not query. But the pull request possibility is open and also to create issues.
    – bueltge
    Feb 26, 2014 at 22:07
1

SOLVED

I installed Query Monitor plugin, which showed me a number of queries and memory usage. Then I turned off one by one plugin to find which plugin consume most memory and how much will number of queries change.

I also discovered that number of queries didn't change speed of page render. I have about 200 queries per page (admin area/frontend site) and it's cause by theme Jarida. But when I switch to Twenty Eleven, there is only 20queries, but render time on server side is still almost same (some miliseconds changes).

So the main reason why my page is so slow, are those three plugins, which consume a lot of memory on server and have a heavy PHP code.

  1. Business Directory Plugin +/- 8MB memory
  2. All-in-One Event Calendar by Timely +/- 9MB memory
  3. NextGEN Gallery by Photocrati +/- 10MB memory

when these three plugins are activated page load rise from 1,2s to 2,8s on my localhost WAMP server, it's even worse on my live site (using shared hosting service).

So If you want to use a lot of heavy plugins like these you have to switch to more powerfull webhosting service. For me is solution to switch to rooted (unmanaged) VPS, which provide me a lot of power to handle a heavy Wordpress plugins like those above.

There is another partialy solution. I am now using temporary WP Super Cache, which is serving all pages as .html files (so there is no need to process PHP code and no database queries). It works fine and really fast, but it's only for frontend website, not for admin area. Admin area is still slow and it's paing to use it.

I am also hitting with my current Wordpress installation 128MB memory limit. In every render page my whole site consume about 100MB memory. So it's really close to not work at all. Shared hosting is not ideal for a Wordpress site with a lot of plugins. There is just not enough computer power to process all PHP code. So it takes up to 6seconds to render one page for one visitor.

2
  • Could you please consider removing your other answer and incorporating it into this one with an explanation of how you found out this information.
    – Dylan
    Mar 10, 2014 at 2:42
  • No problem, I rewrited this answer to help others with same problem. The important is this thing: There is no need to have a lot of visitors per day, the major thing which affect performance of Wordpress site is PHP code which need to be processed. Processing a lot of PHP code (from heavy plugins) took a while on shared low power hosting.
    – usrbowe
    Mar 10, 2014 at 11:14
0

If you're seeing a time reduction when you disable plugins, you can use the P3 plugin to see which plugins are taking a lot of time to run.

1
  • I can see that there is no dependency on number of queries. They are fine. There is problem with PHP processing. And P3 plugin didn't work well. And time reduction with plugins off is not important. Because there is still 2-3sec load time without plugins.
    – usrbowe
    Feb 25, 2014 at 23:25
0

You haven't said how big your site is but if it's a fairly large site using a lot of inserts/updates/deletes to the MySQL database, then it could be that your tables have built up a lot of overhead. Optimizing the tables may help. This can be done within PhpMyAdmin.

Check out the following posts:

https://stackoverflow.com/questions/565997/in-mysql-what-does-overhead-mean-what-is-bad-about-it-and-how-to-fix-it https://stackoverflow.com/questions/1288573/how-much-table-overhead-is-too-much http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html

3
  • Hi, I had run a week ago a WP-Optimize plugin and also I optimized all tables via drop-down menu option in phpymadmin. And there was just lowering time to get queries from 1sec to 0,3s. It is significant, but PHP is working still same time (about 3sec+).
    – usrbowe
    Feb 26, 2014 at 21:11
  • What host are you using and have you tried asking them? Have you changed anything significant on the website in the last 4 months? If not, then it could be an issue with server performance and nothing to do with your code.
    – TomC
    Feb 28, 2014 at 7:36
  • I am using local WEDOS webhosting. It's one of the best. I contact them and they told to meeet their server specs with my PHP scripts, they can't optimize it for me. But on their server specs are only some PHP limits, don't really know what that mean. And I don't change nothing in a year long. I just switched to new theme to deal this slowness weeks ago, but it didn't helped. I don't know, maybe virtual server could help handle more power consuming PHP scripts?
    – usrbowe
    Feb 28, 2014 at 22:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.