WordPress.org

Ready to get started?Download WordPress

Forums

Slow page loading (22 posts)

  1. rob897
    Member
    Posted 9 years ago #

    My site is loading VERY slow well compaired to other WP sites I have been to.
    I am using WP 1.2.2 with Kubrick 1.2.6 and is usually averaging about 1.5 secounds to load completely.
    I have moved to a MySQL 4.0 server now which helped out a little and tried to use gzip enabled, reduced the # of posts that are visible. I am also running phpGiggle but I even disabled this and still did not reflect much in the load times. Any ideas?
    Site is at http://www.snowbrain.com

  2. Mark (podz)
    Support Maven
    Posted 9 years ago #

    Three idiots spawned this page in 2.004 seconds.

    I've seen a whole lot worse.
    Only thing I can see would be to store the ff image locally.

  3. rob897
    Member
    Posted 9 years ago #

    Did that but still no change in speed.

  4. NuclearMoose
    Member
    Posted 9 years ago #

    Feed your gerbils? Maybe they are getting hungry and tired? ;)

  5. rob897
    Member
    Posted 9 years ago #

    Thanks for the humor in the matter but this was aimed as a serious question about WP.

  6. Cypher
    Member
    Posted 9 years ago #

    Is this your personal server or one hosted with someone? What are the spec of the machine?

    WP usually prints out how many queries it performed to create your page. Having an unusually large number of DB queries could have an impact.

    My site loads in about .353-.4 seconds with about 136 queries.

    Regards

  7. rob897
    Member
    Posted 9 years ago #

    Yea its hosted by my works machines which has their own hosting facilities and more than enough bandwidth to spare. The servers are all running the Bluearc storage and the machine are all top of the line as well. I will have to look at the # of queries the site is using at a time.

  8. onenationunderdog
    Member
    Posted 9 years ago #

    I will have to look at the # of queries the site is using at a time

    how do you do this? i have a site ( newsdissector.org ) that occasionally slows to a crawl/standstill. wrote the hosting company (hostgator) asking them to allow me to view processes in phpmyadmin but they said they couldn't do that.

    p.s. i'm running 1.22

  9. timeistight
    Member
    Posted 9 years ago #

    Are you running the Update Linkroll plugin? Try turning it off and see if that makes a difference.

  10. onenationunderdog
    Member
    Posted 9 years ago #

    thanks -- i was running it and turned it off. will report back in a day or two.

  11. MatthiasHeil
    Member
    Posted 9 years ago #

    I have a similar problem and just cannot sort out why my index.php takes between 5 and 9 seconds to load. - Grateful for your help!

    http://www.matthiasheil.de/wordpress/index.php

  12. bi11i
    Member
    Posted 9 years ago #

    i've the same problem - my index.php takes FOREVER to load. PHP apps on my server typically have no problems loading (a dual piii machine), but for some reason.....

    when you talk of WP printing queries - how would i check to see how many it's running if i'm using phpAdmin?

  13. onenationunderdog
    Member
    Posted 9 years ago #

    still having sporadic problems. not too often though.

    i turned off the update linkroll plugin, and tried taking out some and all ping/rpc servers.

    also i am trying to block referrer spam --which could be partly to blame for the slowdown-- but i must have the htaccess syntax wrong b/c it's not working.

    i tried the code snippets listed here:
    http://frenchfragfactory.net/ozh/archives/2005/02/05/no-refer-spam/
    but alas no luck yet. i will keep trying, but may have to resort to this php method:
    http://wordpress.org/support/topic.php?id=22629

    bi11i, i'm not sure how to view/count queries but in phpmyadmin i though 'show processes' (top level, before you select a db) might be relevant. unfort. without super privileges it doeesn't show you much.

    http://dev.mysql.com/doc/mysql/en/show-processlist.html

    more later.

  14. onenationunderdog
    Member
    Posted 9 years ago #

    oh another thing--

    when i get around to it, i will try this page caching hack:

    http://mnm.uib.es/gallir/posts/2005/02/02/111/

  15. gallir
    Member
    Posted 9 years ago #

    Most of the times, the problem of speed in WP is not mainly due to mysql accesess (which are very fast), but compiling the PHP code. If so, try the WP-Cache link shown above.

  16. MatthiasHeil
    Member
    Posted 9 years ago #

    Contrary to Statizice Reloaded, this hack produces error messages in my nightly...-(

    Isn't there a way of finding out what exactly slows down wordpress so much?

    Even navigating the admin pages takes annoyingly long - displaying a page takes about 10 seconds (despite DSL access).

  17. MatthiasHeil
    Member
    Posted 9 years ago #

    bump-)

  18. MatthiasHeil
    Member
    Posted 9 years ago #

    bump-)

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

  19. MatthiasHeil
    Member
    Posted 9 years ago #

    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...

  20. TDavid
    Member
    Posted 9 years ago #

    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.

  21. davidchait
    Member
    Posted 9 years ago #

    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

  22. shadow
    Member
    Posted 9 years ago #

    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 :)

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.