WordPress百万级数据优化|云服务器 ECS - 开发者论坛

唐金琴

<div class="f14 mb10" id="read_tpc">
求召唤坛子里的<span onclick="sendmsg('pw_ajax.php','action=relatetag&tagname=WordPress',this.id)" style="cursor:pointer;border-bottom: 1px solid #FA891B;" id="rlt_8">WordPress</span>大牛<span style="display:none"> R:qW;n%AF </span>&nbsp;<br />好吧，吹了个牛，现在我的<span onclick="sendmsg('pw_ajax.php','action=relatetag&tagname=网站',this.id)" style="cursor:pointer;border-bottom: 1px solid #FA891B;" id="rlt_2">网站</span>只有大概40万左右的文章，但是还在增长。。。<span style="display:none"> RViAwTvY </span>&nbsp;<br />目前遇到了一个<span onclick="sendmsg('pw_ajax.php','action=relatetag&tagname=问题',this.id)" style="cursor:pointer;border-bottom: 1px solid #FA891B;" id="rlt_4">问题</span>：<span style="display:none"> h&lt;QY5=SF </span>&nbsp;<br />某个分类的文章数量超过10万，导致这个分类列表页面载入速度非常慢<span style="display:none"> `R^gU]Z, </span>&nbsp;<br />去好多相关论坛，包括<span onclick="sendmsg('pw_ajax.php','action=relatetag&tagname=阿里云',this.id)" style="cursor:pointer;border-bottom: 1px solid #FA891B;" id="rlt_1"><span onclick="sendmsg('pw_ajax.php','action=relatetag&tagname=阿里',this.id)" style="cursor:pointer;border-bottom: 1px solid #FA891B;" id="rlt_3">阿里</span>云</span>论坛<span onclick="sendmsg('pw_ajax.php','action=relatetag&tagname=RDS',this.id)" style="cursor:pointer;border-bottom: 1px solid #FA891B;" id="rlt_7">RDS</span>板块询问了下关于<span onclick="sendmsg('pw_ajax.php','action=relatetag&tagname=数据库',this.id)" style="cursor:pointer;border-bottom: 1px solid #FA891B;" id="rlt_5"><span onclick="sendmsg('pw_ajax.php','action=relatetag&tagname=数据',this.id)" style="cursor:pointer;border-bottom: 1px solid #FA891B;" id="rlt_6">数据</span>库</span>优化的问题（后来经过排查，数据库该加的索引都加了，不该加的也没乱加，基本没有问题）<span style="display:none"> t]G}AOl </span>&nbsp;<br />某群里有位高手给出的<span onclick="sendmsg('pw_ajax.php','action=relatetag&tagname=建议',this.id)" style="cursor:pointer;border-bottom: 1px solid #FA891B;" id="rlt_9">建议</span>是 修改WordPress调用文章的函数，搞得我云里雾里的<span style="display:none"> [:*)XeRK </span>&nbsp;<br />现在我使用的是&lt;?php if (have_posts() ): while( have_posts() ): the_post(); ?&gt;<span style="display:none"> JucY[`|JV </span>&nbsp;<br />请问使怎么修改可以减轻WordPress对数据库查询的压力？<span style="display:none"> 8&dF </span>&nbsp;<br /><span style="display:none"> j
?QDR </span>&nbsp;<br />
</div>
</div>
<!--content_read-->
</td>
</tr>
<tr>