Have you tried disabling the BBC rdf feed and the gallery random photo block and compared page generation times?
On Tue, 04 Jan 2005 09:08:39 -0600, Tony Bibbs <[EMAIL PROTECTED]> wrote: > The network connection has a measurable impact, however, the page > creation times have nothing to do with networking. So while you point > out a good issue, the script execution is still an issue. > > --Tony > > MAC OS [EMAIL PROTECTED] wrote: > > > Hi, > > > > I've looked at your site a couple of times over the last couple of > > days and from what I can see, your link is just slow, I don't think > > you'll speed it up a lot by changing anything related to PHP, MySQL or > > even Geeklog! Your network connection is slow. > > > > From Belgium: > > > > traceroute to robinbowes.com (81.98.79.17), 30 hops max, 40 byte packets > > 1 server.rocteur.cc (192.168.1.3) 13.393 ms 0.712 ms 0.624 ms > > 2 d5766601.kabel.telenet.be (213.118.102.1) 24.805 ms 25.921 ms > > 9.072 ms > > 3 d5e0fae1.kabel.telenet.be (213.224.250.225) 52.331 ms 16.031 ms > > 24.752 ms > > 4 213.224.126.170 (213.224.126.170) 20.518 ms 14.392 ms 5.822 ms > > 5 212.3.238.5 (212.3.238.5) 10.666 ms 26.303 ms 7.223 ms > > 6 ae-0-16.mp2.brussels1.level3.net (212.3.239.82) 32.168 ms 75.68 > > ms 9.976 ms > > 7 ae1-0.bbr2.london1.level3.net (212.187.128.57) 30.179 ms 28.633 > > ms 19.914 ms > > 8 ge-3-0-0-0.gar2.london1.level3.net (4.68.128.126) 68.755 ms > > 26.792 ms 18.897 ms > > 9 195.50.91.70 (195.50.91.70) 10.93 ms 19.805 ms 16.446 ms > > 10 win-bb-b-so-500-0.inet.ntl.com (62.253.185.202) 24.976 ms 18.177 > > ms 17.178 ms > > 11 bre-bb-a-so-100-0.inet.ntl.com (62.253.185.197) 25.073 ms 63.785 > > ms 26.693 ms > > 12 herm-t2core-a-pos31.inet.ntl.com (62.253.187.18) 20.736 ms > > 26.754 ms 47.562 ms > > 13 herm-t2cam1-a-ge-wan31.inet.ntl.com (80.3.33.6) 23.543 ms 50.513 > > ms 31.777 ms > > 14 ubr02reig-ge10.inet.ntl.com (80.3.34.34) 33.135 ms 27.161 ms > > 36.604 ms > > 15 * * * > > 16 * * * > > 17 * * * > > 18 * * * > > 19 * * * > > 20 * * * > > 21 * * * > > 22 * * * > > 23 * * * > > 24 * * * > > 25 * * * > > 26 * * * > > 27 * * * > > 28 * * * > > 29 * * * > > 30 * * * > > > > From Texas: > > > > traceroute to robinbowes.com (81.98.79.17), 30 hops max, 38 byte packets > > 1 ev1s-66-98-204-1.ev1servers.net (66.98.204.1) 0.261 ms 0.194 ms > > 0.261 ms > > 2 ivhou-207-218-245-14.ev1.net (207.218.245.14) 0.419 ms 0.313 ms * > > 3 hstntx1wce2-gige5-0.wcg.net (65.77.93.53) 1.285 ms 1.189 ms > > 0.986 ms > > 4 hstntx1wcx3-pos9-2-oc48.wcg.net (65.77.93.214) 1.237 ms 1.206 ms * > > 5 dllstx1wcx3-pos14-0-oc192.wcg.net (64.200.210.65) 6.127 ms 5.810 > > ms 5.982 ms > > 6 dllstx9lcx1-pos9-0.wcg.net (64.200.232.210) 5.977 ms 6.077 ms * > > 7 so-2-2-0.edge1.Dallas1.Level3.net (4.68.127.21) 6.443 ms 6.253 > > ms 6.155 ms > > 8 so-1-2-0.bbr2.Dallas1.Level3.net (209.244.15.165) 6.161 ms 6.271 > > ms 6.303 ms > > 9 ae-0-0.bbr2.Washington1.Level3.net (64.159.0.230) 49.233 ms > > 48.996 ms 49.055 ms > > 10 as-0-0.bbr1.London2.Level3.net (4.68.128.101) 116.643 ms 115.730 > > ms * > > 11 ge-3-0-0.gar1.London2.Level3.net (4.68.124.62) 115.976 ms > > 116.097 ms 116.667 ms > > 12 195.50.91.130 (195.50.91.130) 117.500 ms 117.319 ms 118.413 ms > > 13 bre-bb-a-ae0-0.inet.ntl.com (213.105.172.86) 117.672 ms 117.926 > > ms 118.106 ms > > 14 herm-t2core-a-pos31.inet.ntl.com (62.253.187.18) 117.971 ms > > 118.069 ms 118.918 ms > > 15 herm-t2cam1-a-ge-wan31.inet.ntl.com (80.3.33.6) 118.317 ms > > 118.018 ms 118.113 ms > > 16 ubr02reig-ge10.inet.ntl.com (80.3.34.34) 118.791 ms 119.000 ms > > 119.583 ms > > 17 * * * > > 18 * * * > > 19 * * * > > 20 * * * > > > > > > > > On 31 Dec 2004, at 01:23, Robin Bowes wrote: > > > >> Tony Bibbs wrote: > >> > >>> Most of the load is, undoubtedly, on the database. Do you have > >>> MySQL's query cache feature enabled and optimally configured? I'd > >>> start there. > >> > >> > >> Tony, > >> > >> I'm already using turck-mmcache but not cached queries. > >> > >> I turned on cached queries and didn't see any noticeable speed up. I > >> use the following settings in my.cnf: > >> > >> query_cache_type=1 > >> query_cache_size=20M > >> > >> It's definitely turned on: > >> > >> mysql> show variables like '%query_cache%'; > >> +------------------------------+----------+ > >> | Variable_name | Value | > >> +------------------------------+----------+ > >> | have_query_cache | YES | > >> | query_cache_limit | 1048576 | > >> | query_cache_min_res_unit | 4096 | > >> | query_cache_size | 20971520 | > >> | query_cache_type | ON | > >> | query_cache_wlock_invalidate | OFF | > >> +------------------------------+----------+ > >> 6 rows in set (0.00 sec) > >> > >> If I load my home page a few times I see the following cache status: > >> > >> mysql> show status like 'Qcache%'; > >> +-------------------------+----------+ > >> | Variable_name | Value | > >> +-------------------------+----------+ > >> | Qcache_free_blocks | 2 | > >> | Qcache_free_memory | 20802176 | > >> | Qcache_hits | 495 | > >> | Qcache_inserts | 163 | > >> | Qcache_lowmem_prunes | 0 | > >> | Qcache_not_cached | 44 | > >> | Qcache_queries_in_cache | 122 | > >> | Qcache_total_blocks | 289 | > >> +-------------------------+----------+ > >> 8 rows in set (0.00 sec) > >> > >> So, I'm getting cache hits, but it doesn't seem to be making much > >> difference. > >> > >> Any further suggestions? > >> > >> R. > >> -- > >> http://robinbowes.com > >> _______________________________________________ > >> geeklog-users mailing list > >> [EMAIL PROTECTED] > >> http://lists.geeklog.net/listinfo/geeklog-users > >> > > > > _______________________________________________ > > geeklog-users mailing list > > [EMAIL PROTECTED] > > http://lists.geeklog.net/listinfo/geeklog-users > > _______________________________________________ > geeklog-users mailing list > [EMAIL PROTECTED] > http://lists.geeklog.net/listinfo/geeklog-users >
