Site Loading Time Very Slow with Wordpress SEO Plugin

[MikeMobley2002]

This hasn't always been the case, but lately my site has been very slow due to this plugin.

Been using P3 Performance Plugin to capture which ones are slowing down the site and Wordpress SEO is averaging about 60%-70% of my site's loading time making it very slow overall.

Any fix for this? Seems like it's related to a recent version. As of 6/24/14, I am using the latest version of the plugin on the latest version of WP. Thank you.

[shawnlunny]

I am not sure if this is 100% related but I have been checking my logs and see very long queries running. I am using multisite. A sample (and there are alot in there):

Long query on:
wordpress-seo/inc/class-sitemaps.php:342:

SELECT wp_10_term_taxonomy.term_taxonomy_id
FROM wp_10_term_taxonomy
 INNER JOIN wp_10_terms USING (term_id)
WHERE taxonomy = 'post_tag'
 AND wp_10_terms.slug IN ('4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','106','107','108','109','110','111','112','113','114','115','120','121','122','123','124','125','126','127','128','129','143','145','153','154','155','156','157','158','159','161','162','163','164','165','166','168','169','170','174','176','177','178','180','181','182','183','184','185','186','191','193','194','195','197','199','200','201','202','203','205','206','209','210','211','212','214','215','216','217','219','220','221','222','223','224','226','227','229','233','235','236','237','239','240','241','242','243','245','246','247','248','249','250','251','254','255','257','258','259','260','261','262','263','264','265','266','267','268','269','271','273','275','276','277','278','279','280','281','282','283','284','285','288','289','291','292','293','294','297','299','306','307','308','309','310','312','313','315','316','317','318','320','321','322','324','330','334','336','337','340','342','343','344','345','346','347','348','349','351','352','353','354','356','358','359','360','363','365','366','368','369','370','373','375','376','377','379','380','381','383','384','385','386','387','389','390','393','394','395','397','398','399','400','401','402','405','406','411','412','417','418','419','420','421','422','423','424','425','426','427','428','430','431','433','435','437','440','443','445','447','451','456','457','458','459','460','461','463','465','466','469','470','473','474','478','479','481','482','484','487','491','492','496','497','498','499','500','501','503','507','511','512','514','516','517','518','519','522','524','526','527','529','530','531','532','533','534','535','536','539','540','541','542','543','544','545','546','547','548','549','550','552','555','557','558','561','562','565','567','568','572','573','575','576','578','579','580','581','582','583','588','589','590','591','592','593','597','598','599','600','604','605','606','609','614','623','624','627','628','629','630','631','637','639','645','646','647','648','653','654','655','659','661','665','667','672','674','675','679','682','683','685','686','690','693','694','704','706','707','708','709','710','711','721','729','730','738','741','743','744','745','746','751','752','753','756','757','760','761','762','764','769','771','776','777','778','779','780','781','782','783','792','798','799','803','804','805','807','808','809','810','811','814','815','816','819','820','824','827','828','832','833','834','837','838','840','841','844','845','846','847','850','852','854','855','856','857','863','866','867','871','874','876','877','878','881','882','883','884','885','888','889','891','892','894','896','897','898','899','900','902','903','908','909','910','911','912','913','917','918','925','931','935','939','941','945','948','950','951','953','954','955','956','957','961','962','967','981','989','992','997','998','1006','1010','1011','1013','1015','1021','1022','1024','1025','1027','1032','1033','1037','1038','1039','1041','1043','1046','1047','1053','1061','1063','1064','1066','1073','1079','1080','1081','1082','1083','1091','1092','1093','1094','1095','1096','1097','1099','1100','1107','1108','1109','1111','1114','1115','1116','1117','1119','1123','1140','1142','1144','1149','1151','1152','1154','1155','1156','1159','1161','1162','1163','1164','1165','1166','1167','1168','1170','1171','1176','1181','1183','1188','1190','1193','1194','1197','1199','1200','1203','1205','1208','1212','1214','1216','1217','1218','1223','1225','1226','1230','1231','1235','1236','1237','1238','1239','1240','1241','1245','1250','1251','1252','1253','1257','1260','1264','1267','1273','1276','1284','1289','1290','1291','1292','1293','1296','1297','1304','1305','1306','1307','1308','1311','1316','1320','1321','1323','1340','1356','1362','1366','1369','1370','1371','1373','1374','1375','1379','1399','1416','1423','1424','1427','1431','1432','1434','1438','1439','1444','1447','1452','1457','1468','1469','1470','1471','1473','1490','1497','1500','1501','1503','1510','1512','1513','1514','1516','1517','1518','1519','1520','1521','1522','1523','1524','1525','1526','1529','1531','1533','1534','1535','1536','1550','1551','1556','1558','1561','1563','1565','1571','1580','1586','1589','1594','1596','1602','1603','1604','1616','1617','1618','1619','1621','1622','1623','1624','1625','1626','1627','1631','1635','1636','1643','1650','1654','1655','1657','1658','1659','1660','1661','1667','1669','1670','1672','1675','1682','1683','1689','1690','1700','1701','1706','1714','1715','1718','1719','1724','1738','1739','1740','1744','1747','1749','1755','1756','1757','1758','1764','1765','1766','1771','1774','1775','1782','1783','1793','1801','1807','1812','1821','1822','1824','1827','1829','1834','1838','1839','1840','1843','1845','1846','1847','1848','1850','1851','1852','1853','1854','1855','1856','1857','1858','1859','1860','1861','1862','1863','1864','1865','1866','1869','1870','1874','1878','1888','1900','1903','1904','1905','1906','1908','1909','1910','1911','1912','1913','1914','1915','1916','1921','1922','1923','1957','1958','1959','1960','1961','1962','1963','1964','1965','1966','1967','1968','1969','1986','1987','1989','1990','1992','1994','1996','1998','2002','2005','2028','2029','2030','2031','2043','2044','2051','2055','2062','2065','2074','2080','2083','2108','2118','2120','2127','2130','2149','2150','2152','2155','2158','2159','2160','2166','2168','2170','2179','2183','2184','2189','2196','2197','2198','2199','2200','2201','2202','2203','2204','2205','2206','2207','2208','2209','2210','2211','2212','2213','2214','2215','2216','2217','2218','2219','2220','2221','2222','2223','2224','2225','2231','2238','2241','2249','2251','2260','2261','2262','2265','2266','2267','2268','2269','2270','2278','2282','2288','2289','2290','2291','2292','2293','2294','2295','2296','2297','2298','2299','2300','2301')

Is there a better query that can be created here? IN is going to blow up seek time here as the site grows. I can see timeouts being an issue.

[jrfnl]

The sitemap queries have already recently been rewritten. Please test the current GitHub master to see if the problem still exists, if not, please close this issue.

[jdevalk]

Closing for lack of activity. (oh and we fixed loads here and P3 can't properly test our plugin)