Slow page loading

bump-)

bump-)

A terrible suspicion: could it be that php safemode=on slows down wp?

No, that’s not the prob. Safemode is on.

Am I really the onle person on the planet having this problem?

My index takes between 15 and 25 seconds to load now, and navigating the backend is also a test of patience…

No, you aren’t the only one on the planet having this problem.

Over the weekend we worked on importing from Pivot to WordPress, here are the details:

1,587 posts and 800+ comments and I’m getting excess query times and load speed for our front page.

I went through and cut out all the queries that I thought were unnecessary like the archives and categories which don’t change except when one is necessary (I can add those) and I’m not using the built-in link table.

I tracked down a very slow join query and came up with this (not sure if it’s a plugin or port of the WP core yet, though as I haven’t traced it that far):

# Query_time: 70 Lock_time: 2 Rows_sent: 1580 Rows_examined: 5623
SELECT ID, COUNT( comment_ID ) AS ccount
FROM wp_posts
LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = ‘1’)
WHERE post_status = ‘publish’ AND ID IN (1580,1579,1578,1577,1576,1575,1574,1573,1572,1571,1570,1569,1568,1567,1566,1565,1564,1563,1562,1561,1560,1559,1558,1557,1556,1555,1554,1553,1552,1551,1550,1549,1548,1547,1546,1545,1544,1543,1542,1541,1540,1539,1538,1537,1536,1535,1534,1533,1532,1530,1531,1529,1528,1527,1526,1525,1524,1523,1522,1521,1520,1519,1518,1517,1516,1515,1514,1513,1512,1511,1510,1509,1508,1507,1506,1505,1504,1503,1502,1501,1500,1499,1498,1497,1496,1495,1494,1493,1492,1491,1490,1489,1488,1487,1486,1485,1484,1483,1482,1481,1480,1479,1478,1477,1476,1475,1474,1473,1472,1471,1470,1469,1468,1467,1466,1465,1464,1463,1462,1461,1460,1459,1458,1457,1456,1455,1454,1453,1451,1450,1449,1448,1452,1447,1446,1445,1444,1443,1442,1441,1440,1439,1438,1437,1436,1435,1434,1433,1432,1431,1429,1430,1428,1427,1426,1425,1424,1423,1421,1420,1422,1419,1418,1417,1415,1416,1413,1414,1412,1410,1411,1409,1408,1407,1404,1406,1405,1403,1402,1401,1400,1399,1398,1397,1396,1395,1394,1393,1392,1391,1389,1390,1388,1386,1387,1385,1384,1383,1382,1381,1379,1380,1378,1377,1376,1370,1372,1375,1374,1373,1371,1369,1368,1367,1366,1365,1359,1364,1357,1356,1358,1363,1362,1361,1360,1355,1354,1353,1352,1351,1350,1349,1348,1347,1346,1345,1344,1343,1342,1341,1340,1339,1338,1337,1336,1335,1334,1333,1332,1331,1330,1329,1328,1327,1326,1325,1324,1323,1322,1321,1320,1319,1318,1317,1316,1315,1314,1313,1312,1311,1310,1309,1308,1307,1306,1305,1304,1303,1302,1301,1300,1299,1298,1297,1296,1295,1294,1293,1292,1291,1290,1289,1288,1287,1286,1285,1284,1283,1282,1281,1280,1279,1278,1277,1276,1275,1274,1273,1272,1271,1270,1269,1268,1267,1266,1265,1264,1263,1262,1261,1260,1259,1258,1257,1256,1255,1254,1253,1252,1251,1250,1249,1248,1247,1246,1245,1244,1243,1242,1241,1240,1239,1238,1237,1236,1235,1234,1233,1232,1231,1230,1229,1228,1227,1226,1225,1224,1223,1222,1221,1220,1219,1218,1217,1216,1215,1214,1213,1212,1211,1210,1209,1208,1207,1206,1205,1204,1203,1202,1201,1200,1199,1198,1197,1196,1195,1194,1193,1192,1191,1190,1189,1188,1187,1186,1185,1184,1183,1182,1181,1180,1179,1178,1177,1176,1175,1174,1173,1172,1171,1170,1169,1168,1167,1166,1165,1164,1163,1162,1161,1160,1159,1158,1157,1156,1155,1154,1153,1152,1151,1150,1149,1148,1147,1146,1145,1144,1143,1142,1141,1140,1139,1138,1137,1136,1135,1134,1133,1132,1131,1130,1129,1128,1127,1126,1125,1124,1123,1122,1121,1120,1119,1118,1117,1116,1115,1114,1113,1112,1111,1110,1109,1108,1107,1106,1105,1104,1103,1102,1101,1100,1099,1098,1097,1096,1095,1094,1093,1092,1091,1090,1089,1088,1087,1086,1085,1084,1083,1082,1081,1080,1079,1078,1077,1076,1075,1074,1073,1072,1071,1070,1069,1068,1067,1066,1065,1064,1063,1062,1061,1060,1059,1058,1057,1056,1055,1054,1053,1052,1051,1050,1049,1048,1047,1046,1045,1044,1043,1042,1041,1040,1039,1038,1037,1036,1035,1034,1033,1032,1031,1030,1029,1028,1027,1026,1025,1024,1023,1022,1021,1020,1019,1018,1017,1016,1015,1014,1013,1012,1011,1010,1009,1008,1007,1006,1005,1004,1003,1002,1001,1000,999,998,997,996,995,994,993,992,991,990,989,988,987,986,985,984,983,982,981,980,979,978,977,976,975,974,973,972,971,970,969,968,967,966,965,964,963,962,961,960,959,958,957,956,955,954,953,952,951,950,949,948,947,946,945,944,943,942,941,940,939,938,937,936,935,934,933,932,931,930,929,928,927,926,925,924,923,922,921,920,919,918,917,916,915,914,913,912,911,910,909,908,907,906,905,904,903,902,901,900,899,898,897,896,895,894,893,892,891,890,889,888,887,886,885,884,883,882,881,880,879,878,877,876,875,874,873,872,871,870,869,868,867,866,865,864,863,862,861,860,859,858,857,856,855,854,853,852,851,850,849,848,847,846,845,844,843,842,841,840,839,838,837,836,835,834,833,832,831,830,829,828,827,826,825,824,823,822,821,820,819,818,817,816,815,814,813,812,811,810,809,808,807,806,805,804,803,802,801,800,799,798,797,796,795,794,793,792,791,790,789,788,787,786,785,784,783,782,781,780,779,778,777,776,775,774,773,772,771,770,769,768,767,766,765,764,763,762,761,760,759,758,757,756,755,754,753,752,751,750,749,748,747,746,745,744,743,742,741,740,739,738,737,736,735,734,733,732,731,730,729,728,727,726,725,724,723,722,721,720,719,718,717,716,715,714,713,712,711,710,709,708,707,706,705,704,703,702,701,700,699,698,697,696,695,694,693,692,691,690,689,688,687,686,685,684,683,682,681,680,679,678,677,676,675,674,673,672,671,670,669,668,667,666,665,664,663,662,661,660,659,658,657,656,655,654,653,652,651,650,649,648,647,646,645,644,643,642,641,640,639,638,637,636,635,634,633,632,631,630,629,628,627,626,625,624,623,622,621,620,619,618,617,616,615,614,613,612,611,610,609,608,607,606,605,604,603,602,601,600,599,598,597,596,595,594,593,592,591,590,589,588,587,586,585,584,583,582,581,580,579,578,577,576,575,574,573,572,571,570,569,568,567,566,565,564,563,562,561,560,559,558,557,556,555,554,553,552,551,550,549,548,547,546,545,544,543,542,541,540,539,538,537,536,535,534,533,532,531,530,529,528,527,526,525,524,523,522,521,520,519,518,517,516,515,514,513,512,511,510,509,508,507,506,505,504,503,502,501,500,499,498,497,496,495,494,493,492,491,490,489,488,487,486,485,484,483,482,481,480,479,478,477,476,475,474,473,472,471,470,469,468,467,466,465,464,463,462,454,461,460,459,458,457,456,455,453,452,451,450,449,448,447,446,445,444,443,442,441,440,439,438,437,435,436,434,433,432,431,430,428,429,427,426,413,425,424,423,422,421,420,419,418,417,416,415,414,412,411,410,409,408,407,406,405,404,403,402,401,399,400,397,398,396,395,394,391,393,392,388,390,382,389,387,366,386,385,384,383,381,380,379,378,377,376,371,375,374,373,372,370,369,368,234,367,358,365,364,363,362,361,360,359,357,356,341,303,355,354,353,352,351,345,350,349,348,347,346,343,344,342,327,339,340,338,337,336,335,334,333,331,332,330,311,329,328,326,325,324,323,322,309,321,320,319,318,317,315,312,316,314,313,308,310,307,306,305,304,300,302,276,301,265,293,299,298,297,296,295,261,294,292,291,290,272,289,288,287,286,285,284,283,282,281,280,279,278,277,275,262,274,273,271,270,269,268,267,266,264,263,260,257,259,258,256,255,254,251,253,252,250,249,248,244,247,245,246,243,242,241,240,233,239,238,237,236,235,230,232,231,224,229,228,225,227,226,221,217,223,222,220,219,218,216,210,215,214,213,212,211,201,209,200,204,208,207,206,205,202,203,194,198,199,197,196,195,193,190,192,191,189,188,187,186,185,184,182,183,181,180,179,178,177,175,176,170,174,173,172,171,154,169,168,167,165,166,136,164,163,162,161,159,160,158,157,156,128,151,145,148,150,155,153,152,149,147,146,144,36,143,142,127,141,138,140,139,137,133,135,134,130,132,131,126,129,125,124,123,122,121,120,119,118,117,116,115,114,108,113,112,111,110,109,107,106,105,104,103,101,102,99,100,98,97,95,96,94,93,92,91,90,89,88,75,87,86,85,84,83,82,81,80,61,79,78,63,77,74,76,73,70,71,68,72,69,67,64,66,65,62,59,60,58,56,57,54,55,50,53,51,52,49,47,46,48,45,42,44,43,41,40,39,38,37,34,35,32,33,30,25,29,31,18,20,26,28,27,22,24,23,19,15,21,17,16,14,13,10,12,7,11,9,8,6,5,4,3,2,1)
GROUP BY ID;

###
Hope that copy/paste doesn’t hose the formatting of this thread.

Anybody else run into this? I’m tracking down this join query and seeing about optimizing the query so it executes more efficiently.

Yeah, I’m still a believer that the current comment count should be kept IN the post record itself, updated whenever a comment is added/deleted, rather than CONSTANTLY querying with the nasty JOIN. If you have a HUGE number of posts, and a lot of comments, such a join could be somewhat of a hit.

That particular query, just to explain, is for displaying comment counts next to each post on an index page…

I always start with a clean theme, using minimal extra stuff (no comment counts, no blogroll/link lists, no archive lists), and see how THAT runs as a comparative. That should be minimal SQL queries overall. No extra plugins, no extra sidebar stuff, no extra post info. From there, add things in one at a time, until something triggers larger slowdown.

The static-caching stuff is one approach — I myself use a lot of dynamic code on my site, and caching can disable a lot without refactoring my template/theme. I for one would rather find the root queries, plugins, template tags/functions, etc. that are showing up as bottlenecks and let more people know about them.

-d

Is anyone any the wiser with this whole issue of sites running slow?

I have about 6 WP sites on a server and yet only one is going incredibly slow. I have tried disabling the bulk of the plugins and still no signs of improvement.

What else do I need to be looking for ?

Any help ould be much appreciated ??