我的博客有70多万篇文章,我的分类结构如下:
猫1(ID:3)
- 我使用以下SQL语句获取文章:
因此,查询速度非常慢(大约3 seconds).SELECT ID FROM apk_posts INNER JOIN apk_term_relationships ON (apk_posts.ID = apk_term_relationships.object_id) INNER JOIN apk_term_taxonomy ON (apk_term_relationships.term_taxonomy_id = apk_term_taxonomy.term_taxonomy_id) WHERE (apk_term_taxonomy.term_id = IN (2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22) AND apk_term_taxonomy.taxonomy = \'category\') ORDER BY apk_posts.post_date DESC LIMIT 10;
如何加快查询速度?