tdavid

v0.2 of the pivot to wp importer script has been posted (same URL as above). paradoxdruid, I incorporated your suggestion (the db table bugs I’d been notified by another person about earlier). Any comments on that please hit me up on the blog.

I’m curious: you only made suggestions to 3 lines of code, but there are some 250+ lines of code in that importer, so I’m confused by the it was “90% done” part of your comment above unless you added a bunch more code (y/n?)

Anyway, I’d be interested in seeing this other code you modified/wrote so perhaps we could combine to make one super easy import script for folks to be able to use to switch if they liked.

One thing I’d like to change is the config section to be through the browser like the WP install. It’s easier for folks that aren’t familiar with coding to follow that type of UI.

Also, I noticed there was our standard commercial copyright stub on that file. That should *not* have been there and will be changed to a GNU license just like WordPress in the next update. People are welcome to use, reuse and modify that code despite the copyright stub.

Drop me a line and get in touch on this, paradoxdruid 🙂 You can call my office if you like or stop by our irc chat at irc.scriptschool.com #scriptschool. Thanks 🙂

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.