Posted 5 years ago #
As much as I love the features of WordPress, it seems that just about every site with a lot of content (say 1 year +) seems to have fairly poor page draw speed.
Does anyone have examples of a WordPress site with 1 year+ of content that is fast (read: fast page draws)?
And if you think webhosting is the culprit, I am not looking for the cheapest webhost; I am willing to pay more if it will help.
Thanks in advance,
Chris
Posted 5 years ago #
sumocomputers,
I have been facing the same issue with over 16000 posts and have seen the performance of my site degrade. But I just put in a solution that did the trick. My initial load query is down from 6.8s to 0.4 seconds and the heaviest category lookup has come down from 4.3 seconds to .4 seconds as well.
You will have to edit [wp-includes/classes.php] file
Look for the line
$request = " SELECT $distinct * FROM $wpdb->posts $join WHERE 1=1" . $where . " GROUP BY " . $groupby . " ORDER BY " . $orderby . " $limits";
And replace it by
$request = " SELECT * FROM $wpdb->posts $join WHERE 1=1" . $where . " ORDER BY " . $orderby . " $limits";
That basically removes the unnecessary DISTINCT on ID which is a primary key in wp_posts table anyway and cannot be duplicated. The distinct and group by are the real killers.
Atul Bansal (http://www.sahihai.com)
WP-Cache. Takes some work, but very worth it if speed is critical.
Posted 4 years ago #
hi atulbansal,
I tried your code and it does improve my wordpress performance alot. However, when I click on next page, the code breaks. My blog has about 600 posts and 1000 comments. Currently, I have to set very long timeout for WP-Cache plugin so that the slow performance of my blog won't affect too many users. However, I hope somebody could tell me how to fix this problem.
I run wordpress 2.0.2. Do I have to upgrade it to get better performance?
This topic has been closed to new replies.
