Teh Lack of Speed - Teh Forum

<body> <div id="header"> <span class="left"> <span class="back"><a href="lthread_list.php?webtag=DEFAULT"><span class="image mobile_back" title="Back"></span></a></span> <span class="image mobile_logo" title="Beehive Forum Logo"></span> </span> <ul> <li> <a class="reply_all" href="lpost.php?webtag=DEFAULT&reply_to=29871.0&return_msg=29871.6"> <span class="image mobile_reply_all"></span><span class="text">Reply to All</span> </a> </li> <li> <a class="navigation" href="#"> <span class="image mobile_navigation"></span><span class="text">Show messages</span> </a> </li> <li> <a class="main" href="#"><span class="image mobile_menu" title="Menu"></span> </a> </li> </ul> </div> <div class="menu main"> <ul> <li><a href="lthread_list.php?webtag=DEFAULT">Messages</a></li> <li><a href="lpm.php?webtag=DEFAULT">Inbox</a></li> <li><a href="lsearch.php?webtag=DEFAULT">Search</a></li> <li><a href="llogon.php?webtag=DEFAULT">Login</a></li> </ul> </div> <div class="menu navigation"><a href="lmessages.php?webtag=DEFAULT&msg=29871.1">1–10</a><a href="lmessages.php?webtag=DEFAULT&msg=29871.11">11–20</a>…<a href="lmessages.php?webtag=DEFAULT&msg=29871.71">71–72</a></div> <div id="page_content"> <h3 class="thread_title"><a href="index.php?webtag=DEFAULT&amp;msg=29871.6">Teh Lack of Speed</a> </h3> <div id="messages" data-navigation="29871_6_72_10"> <a name="a29871_6"></a><div class="message" id="message_29871_6"> <div class="message_header"> <div class="message_from"> From: Wattsy (SLAYERPUNX)<span class="message_time"> 3 Jul 2006 11:37</span> <div class="clearer"></div> </div><div class="message_to">To: Peter (BOUGHTONP) <span><span class="image post_read" title="Read: 3 Jul 2006 11:42"></span></span> <span class="message_count">6 of 72</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=29871.6">29871.6</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=29871.3">29871.3</a></div> <div class="message_body"> <p>It seems from all the computer I use teh is very slow. I only use IE6 and IE7. I am strapped into a phat pipe here at work and have no problems what so ever with any other pages.</p> <p> </p> <p>Its been like this for a while now but this is the first time I have moaned.</p> <p> </p> <p>I blame the labour party and ebay.</p> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=29871.6&return_msg=29871.6" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="29871.6"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a29871_7"></a><div class="message" id="message_29871_7"> <div class="message_header"> <div class="message_from"> From: mr_swayzee<span class="message_time"> 3 Jul 2006 11:39</span> <div class="clearer"></div> </div><div class="message_to">To: Wattsy (SLAYERPUNX) <span><span class="image post_read" title="Read: 3 Jul 2006 11:40"></span></span> <span class="message_count">7 of 72</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=29871.7">29871.7</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=29871.6#a29871_6" target="_self">29871.6</a></div> <div class="message_body"> I blame it on the boogie, and Canada.<br /> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=29871.7&return_msg=29871.6" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="29871.7"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a29871_8"></a><div class="message" id="message_29871_8"> <div class="message_header"> <div class="message_from"> From: Wattsy (SLAYERPUNX)<span class="message_time"> 3 Jul 2006 11:45</span> <div class="clearer"></div> </div><div class="message_to">To: mr_swayzee <span><span class="image post_read" title="Read: 3 Jul 2006 11:53"></span></span> <span class="message_count">8 of 72</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=29871.8">29871.8</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=29871.6#a29871_7" target="_self">29871.7</a></div> <div class="message_body"> <p>It's not a real country anyway!</p> <p> </p> <p><br /> (and its speeded up a bit, has someone threatened the server?)</p> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=29871.8&return_msg=29871.6" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="29871.8"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a29871_9"></a><div class="message" id="message_29871_9"> <div class="message_header"> <div class="message_from"> From: Stoo<span class="message_time"> 3 Jul 2006 13:12</span> <div class="clearer"></div> </div><div class="message_to">To: Wattsy (SLAYERPUNX) <span><span class="image post_read" title="Read: 3 Jul 2006 13:14"></span></span> <span class="message_count">9 of 72</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=29871.9">29871.9</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=29871.1">29871.1</a></div> <div class="message_body"> I'm getting similarly horrible loading times - i'm averaging about 2 minutes per thread on the standard forum.<br /> <br /> HOWEVER! I find that using the 'Light' version is relatively nippy - still slower than most other places, but it's definitely usable.<br /> <br /> No problems with any other websites whatsoever, so i'm pretty sure it's not a problem my end. </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=29871.9&return_msg=29871.6" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="29871.9"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a29871_10"></a><div class="message" id="message_29871_10"> <div class="message_header"> <div class="message_from"> From: Wattsy (SLAYERPUNX)<span class="message_time"> 3 Jul 2006 13:15</span> <div class="clearer"></div> </div><div class="message_to">To: Stoo <span><span class="image post_read" title="Read: 3 Jul 2006 13:33"></span></span> <span class="message_count">10 of 72</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=29871.10">29871.10</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=29871.6#a29871_9" target="_self">29871.9</a></div> <div class="message_body"> <p>Its gone slow again now <span class="emoticon e_sad" title=":("><span class="e__">:(</span></span></p> <p> </p> <p>Also</p> <p> </p> <p>Where has LOST gone?</p> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=29871.10&return_msg=29871.6" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="29871.10"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a29871_11"></a><div class="message" id="message_29871_11"> <div class="message_header"> <div class="message_from"> From: Stoo<span class="message_time"> 3 Jul 2006 13:33</span> <div class="clearer"></div> </div><div class="message_to">To: Wattsy (SLAYERPUNX) <span><span class="image post_read" title="Read: 3 Jul 2006 13:39"></span></span> <span class="message_count">11 of 72</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=29871.11">29871.11</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=29871.6#a29871_10" target="_self">29871.10</a></div> <div class="message_body"> Lost is where it's always been, as far as i'm aware:<br /> <a href="http://www.yourlost.com/forum/">http://www.yourlost.com/forum/</a> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=29871.11&return_msg=29871.6" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="29871.11"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a29871_12"></a><div class="message" id="message_29871_12"> <div class="message_header"> <div class="message_from"> From: Wattsy (SLAYERPUNX)<span class="message_time"> 3 Jul 2006 13:40</span> <div class="clearer"></div> </div><div class="message_to">To: Stoo <span><span class="image post_read" title="Read: 3 Jul 2006 14:09"></span></span> <span class="message_count">12 of 72</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=29871.12">29871.12</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=29871.6#a29871_11" target="_self">29871.11</a></div> <div class="message_body"> How strange, my link doesn't work but yours did <span class="emoticon e_plain" title=":|"><span class="e__">:|</span></span> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=29871.12&return_msg=29871.6" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="29871.12"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a29871_13"></a><div class="message" id="message_29871_13"> <div class="message_header"> <div class="message_from"> From: Woggy<span class="message_time"> 3 Jul 2006 13:59</span> <div class="clearer"></div> </div><div class="message_to">To: ALL<span class="message_count">13 of 72</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=29871.13">29871.13</a></div> <div class="message_body"> <p>It's bloody terrible for me, from home and from work, so it isn't my connection (which is fast on other websites).</p> <p> </p> <p>That's why I haven't posted much, I could make a cup of coffee waiting for threads to load.</p> <p> </p> <p>EDIT: This just opened in another tab while I waited for this to post, 'Dictionary, Initialising'. So far it's been ages. Looks like it could be a spell checking problem?</p> <p> </p> <p><a href="http://www.tehforum.co.uk/forum/dictionary.php?webtag=DEFAULT&obj_id=t_content">http://www.tehforum.co.uk/forum/dictionary.php?webtag=DEFAULT&obj_id=t_content</a></p><div class="edit_text">EDITED: 3 Jul 2006 14:06 by WOGGY</div> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=29871.13&return_msg=29871.6" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="29871.13"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a29871_14"></a><div class="message" id="message_29871_14"> <div class="message_header"> <div class="message_from"> From: Matt<span class="message_time"> 3 Jul 2006 17:02</span> <div class="clearer"></div> </div><div class="message_to">To: Woggy <span><span class="image post_read" title="Read: 3 Jul 2006 21:52"></span></span> <span class="message_count">14 of 72</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=29871.14">29871.14</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=29871.6#a29871_13" target="_self">29871.13</a></div> <div class="message_body"> It's not as simple as saying it's the dictionary causing the slowness. <br /> <br /> But it is as simple as saying that this server can't cope.<br /> <br /> Problem is when a query is performed the tables required are locked so no data can be inserted or modified at the same time. If the server is under load the query is going to take longer to perform due to lack of resources and because of the nature of PHP and MySQL if you get annoyed by the slowness and keep clicking links or refreshing pages trying to force it to load the page all you're doing is queuing up more queries for MySQL to execute and increasing the load on the server. <br /> <br /> The thread list uses one of the most complex queries in Beehive so you can imagine what happens if you keep trying to refresh the thread list all the time.<br /> <br /> It's not easy balancing the server performance between Apache and MySQL mostly because I haven't a clue how to set up MySQL to best suit our needs and searching for the right information reveals fuck all because all it's all along the lines of "try this" and "do that" without actually telling you what it does or why you should change it.<br /> <br /> So yeah. Like it or lump it or we a) prune the database <i>drastically</i> or b) get together some money again to upgrade the hosting. We should probably do that again soon anyway as we'll need to be paying soon I would have thought. </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=29871.14&return_msg=29871.6" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="29871.14"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a29871_15"></a><div class="message" id="message_29871_15"> <div class="message_header"> <div class="message_from"> From: Dave!!<span class="message_time"> 3 Jul 2006 17:15</span> <div class="clearer"></div> </div><div class="message_to">To: Matt <span><span class="image post_read" title="Read: 3 Jul 2006 17:58"></span></span> <span class="message_count">15 of 72</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=29871.15">29871.15</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=29871.6#a29871_14" target="_self">29871.14</a></div> <div class="message_body"> <p>Could you give me details about how much load Beehive normally places on the server, how much bandwidth it uses etc?</p> <p> </p> <p>Only our old server at work is being largely replaced within the next few weeks and the old one will be still hooked up and in use, but doing very little. There's a possibility of being able to use it to host Teh as well. I'd have to look into it though. Incidentally, the machine is a 1.13GHz PIII with 512MB RAM and is currently running Server 2000.</p> <p> </p> <p>Like I say, no promises or anything, but it's a possibility! <span class="emoticon e_smile" title=":)"><span class="e__">:)</span></span></p> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=29871.15&return_msg=29871.6" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="29871.15"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div></div> <div class="message_page_footer"> <ul> <li class="right_col"><form accept-charset="utf-8" method="get" action="lmessages.php" target="_self"><input type="hidden" name="webtag" id="webtag" class="bhinputtext" value="DEFAULT" dir="ltr" /><input type="hidden" name="msg" id="msg" class="bhinputtext" value="29871.16" dir="ltr" /><input type="submit" name="submit" id="keep_reading" value="Keep reading…" class="button" /></form></li> </ul> </div> </div> </body>