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.18"> <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.21">21–30</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.18">Teh Lack of Speed</a> </h3> <div id="messages" data-navigation="29871_18_72_10"> <a name="a29871_18"></a><div class="message" id="message_29871_18"> <div class="message_header"> <div class="message_from"> From: paul<span class="message_time"> 3 Jul 2006 18:19</span> <div class="clearer"></div> </div><div class="message_to">To: Kriv <span><span class="image post_read" title="Read: 3 Jul 2006 19:56"></span></span> <span class="message_count">18 of 72</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=29871.18">29871.18</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=29871.17">29871.17</a></div> <div class="message_body"> <p>I think I see what you're saying there, i.e. dump most of whats already 'archived' here to another place and reference it from here?</p> <p> </p> <p>On the other hand, I would question whether we /really/ need to keep all the old posts?</p> <p> </p> <p>Does anyone ever read them?</p> <p> </p> <p>Are we just keeping them for the sake of keeping them?</p> <p> </p> <p>Personally, I think pruning is the order of the day.</p> <p> </p> <p>If someone cares enough to do a Kenny and dump everything into an 'attic' somewhere, all well and good, otherwise let it go...</p> <p> </p> <p><span class="emoticon e_smile_big_nose" title=":O)"><span class="e__">:O)</span></span></p> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=29871.18&return_msg=29871.18" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="29871.18"> <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_19"></a><div class="message" id="message_29871_19"> <div class="message_header"> <div class="message_from"> From: Matt<span class="message_time"> 3 Jul 2006 18:19</span> <div class="clearer"></div> </div><div class="message_to">To: Kriv <span><span class="image post_read" title="Read: 3 Jul 2006 19:56"></span></span> <span class="message_count">19 of 72</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=29871.19">29871.19</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=29871.17">29871.17</a></div> <div class="message_body"> <p>It's a possibility.</p> <p> </p> <p>To keep it as a database yet seperate from the live forum is going to mean it could potentially have the same impact on performance as we have with it remaining as it is now because we'd still have only the one MySQL server with the database it can't cope with. Unless the archive was moved to a different machine, which means paying for it and setting it all up seperatly, but making it read-only.</p> <p> </p> <p>We could dump it to static HTML files and that has been talked about before but I would need help implementing that feature in Beehive and we'd have to have substantial downtime while the archive is created.</p> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=29871.19&return_msg=29871.18" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="29871.19"> <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_20"></a><div class="message" id="message_29871_20"> <div class="message_header"> <div class="message_from"> From: Matt<span class="message_time"> 3 Jul 2006 18:28</span> <div class="clearer"></div> </div><div class="message_to">To: paul <span><span class="image post_read" title="Read: 3 Jul 2006 19:52"></span></span> <span class="message_count">20 of 72</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=29871.20">29871.20</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=29871.18#a29871_18" target="_self">29871.18</a></div> <div class="message_body"> <p>I'd have a problem with dumping it.</p> <p> </p> <p>There is a massive amount of knowledge and wealth here. There are countless solutions to problems that people have had and some very interesting discussions that everyone should read at least once. There is no doubt also a lot of crap, but it would be a shame to loose all the good stuff just for the sake of keeping everything ship shape.</p> <p> </p> <p>Recently we've been getting quite a few hits from search engines for people looking for solutions to their problems which is nice to see. Although I'm not sure how the managed to find us, because I've tried searching for things I know are here and we never show up, but they'er definitely finding us. I'd like to think the posts they find are useful as well.</p> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=29871.20&return_msg=29871.18" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="29871.20"> <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_21"></a><div class="message" id="message_29871_21"> <div class="message_header"> <div class="message_from"> From: milko<span class="message_time"> 3 Jul 2006 19:01</span> <div class="clearer"></div> </div><div class="message_to">To: Matt <span><span class="image post_read" title="Read: 3 Jul 2006 20:01"></span></span> <span class="message_count">21 of 72</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=29871.21">29871.21</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=29871.14">29871.14</a></div> <div class="message_body"> There's a reasonable amount of funds in the Amazon thingy, although not much has been contributed that way of late, lack of publicity and stuff. </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=29871.21&return_msg=29871.18" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="29871.21"> <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_22"></a><div class="message" id="message_29871_22"> <div class="message_header"> <div class="message_from"> From: paul<span class="message_time"> 3 Jul 2006 19:56</span> <div class="clearer"></div> </div><div class="message_to">To: Matt <span><span class="image post_read" title="Read: 3 Jul 2006 20:01"></span></span> <span class="message_count">22 of 72</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=29871.22">29871.22</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=29871.18#a29871_20" target="_self">29871.20</a></div> <div class="message_body"> <p>I totally understand where you're coming from, but also look at all the shite I've got stashed in my loft/shed/garage!</p> <p> </p> <p>Why not look at getting a static HTML archive site for it all then? Would that be a suitable compromise?</p> <p> </p> <p><span class="emoticon e_smile_big_nose" title=":O)"><span class="e__">:O)</span></span></p> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=29871.22&return_msg=29871.18" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="29871.22"> <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_23"></a><div class="message" id="message_29871_23"> <div class="message_header"> <div class="message_from"> From: Kriv<span class="message_time"> 3 Jul 2006 19:59</span> <div class="clearer"></div> </div><div class="message_to">To: Matt <span><span class="image post_read" title="Read: 3 Jul 2006 20:01"></span></span> <span class="message_count">23 of 72</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=29871.23">29871.23</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=29871.18#a29871_19" target="_self">29871.19</a></div> <div class="message_body"> <p>HTML wouls stop old posts being archived, therfore stopping the need for intense queries... I'd imagine.</p> <p> </p> <p>While I couldn't help.. I can donate my PC and bandwidth for conversion purposes if needed in some way.</p> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=29871.23&return_msg=29871.18" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="29871.23"> <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_24"></a><div class="message" id="message_29871_24"> <div class="message_header"> <div class="message_from"> From: Drew (X3N0PH0N)<span class="message_time"> 4 Jul 2006 04:05</span> <div class="clearer"></div> </div><div class="message_to">To: Matt <span><span class="image post_read" title="Read: 4 Jul 2006 07:33"></span></span> <span class="message_count">24 of 72</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=29871.24">29871.24</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=29871.18#a29871_20" target="_self">29871.20</a></div> <div class="message_body"> <p>Whenever this happens, I'm all for archiving it.</p> <p> </p> <p>I know you've explained this, but I think I didn't understand the explanation. What's the problem (in terms of performance) in making this forum read-only and then starting afresh?</p> <p> </p> <p>I mean, I realise the archived forum would still have the same performance issues but surely it would be used so little as to not matter? It would be used as much as people use the search function currently, at most. Which for me, is very very seldom. Regardless, the overall load should be much lower shouldn't it?</p> <p> </p> <p>If for some reason that's not practical, how about dumping this database, getting someone to host this forum read-only somewhere and again, starting afresh here. The archive might fall over a bit but... better that than this place suffering. The slowness is not the fault of the software or whatever, just the size of this place. Butif it's keeping people from posting then we need to make sacrifices I think.</p> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=29871.24&return_msg=29871.18" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="29871.24"> <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_25"></a><div class="message" id="message_29871_25"> <div class="message_header"> <div class="message_from"> From: Manthorp<span class="message_time"> 4 Jul 2006 07:00</span> <div class="clearer"></div> </div><div class="message_to">To: ALL<span class="message_count">25 of 72</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=29871.25">29871.25</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=29871.18#a29871_24" target="_self">29871.24</a></div> <div class="message_body"> Incidentally, and I assume this serves to illustrate Matt's analysis, it loads better for me - or rather, less slowly - in the ungodly hours of the morning. </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=29871.25&return_msg=29871.18" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="29871.25"> <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_26"></a><div class="message" id="message_29871_26"> <div class="message_header"> <div class="message_from"> From: Dave!!<span class="message_time"> 4 Jul 2006 08:09</span> <div class="clearer"></div> </div><div class="message_to">To: Manthorp <span><span class="image post_read" title="Read: 4 Jul 2006 09:06"></span></span> <span class="message_count">26 of 72</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=29871.26">29871.26</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=29871.18#a29871_25" target="_self">29871.25</a></div> <div class="message_body"> It's faster for me in the mornings as well, but with onl 6 members online compared with some afternoons and evenings when there's 20-30 online and there you go. </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=29871.26&return_msg=29871.18" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="29871.26"> <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_27"></a><div class="message" id="message_29871_27"> <div class="message_header"> <div class="message_from"> From: Peter (BOUGHTONP)<span class="message_time"> 4 Jul 2006 19:41</span> <div class="clearer"></div> </div><div class="message_to">To: Matt <span><span class="image post_read" title="Read: 4 Jul 2006 21:12"></span></span> <span class="message_count">27 of 72</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=29871.27">29871.27</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=29871.14">29871.14</a></div> <div class="message_body"> What about using bind variables?<br /> <br /> Bah, looks like it would mean restricting Beehive to PHP5+MySQL 4.1 (or later), <br /> but it should give a significant boost to query performance; maybe it could be added as a branch/mod?<br /> <br /> <br /> <br /> Also (this may already be done, but I couldn't see anything on a quick glance), what about having shortcut thingies - um, by which I mean something similar to this:<br /> <div class="quotetext" id="code-Pseudo-PHP"><b>Pseudo-PHP code:</b></div><pre class="code">if (looking_for_unread_messages && $_SERVER['LAST_BH_MESSAGE'] > $_SESSION['USER_LAST_THREADLIST']) { // perform query as normal } else { // do cut-down query or cached query or whatever } </pre><br /> ie: Store a server-wide variable of the last message post time, and use it to determine if there's any point even running a [complete] query.<br /> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=29871.27&return_msg=29871.18" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="29871.27"> <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.28" dir="ltr" /><input type="submit" name="submit" id="keep_reading" value="Keep reading…" class="button" /></form></li> </ul> </div> </div> </body>