Admin Posted July 14, 2008 Report Share Posted July 14, 2008 A little behind schedule, but things should be "finished" This is what has been done today; Forum Security upgrades performed Report feature fixed so that it works for all members Forum images moved to a separate site/IP on the forum server- The effect of this is that instead of opening 1 connection to the forum, your browser will now open 2 connections to the forum; 1 to the forum files and another one to get the images. Two separate processes serving content will provide parallel processing, utilizing our multi-core processors and your browser loads 2 connections faster than 1. Server Hardware upgraded - Our server was over a year old. Prices has now dropped on new equipment, so we now get a more powerful processor and more RAM, without paying more. Software/DB optimization (ongoing process) - This is where the biggest focus has been. Server and DB has been optimized. Due to increased computing power, I have added more indexes to the databases, to speed up data fetching. Further utilizing of PHP acceleration. Instead of loading and compiling PHP scripts, the compiled PHP scripts are now cached (kept in the server memory) and serves up pages faster. The process of optimizing the database will take about a week, but this should not be noticeable to the members except that the site/pages will load faster. Search engine optimized further. The entire database is now re-indexed every 15 minutes and this takes less than 10 seconds!! Quote Link to comment Share on other sites More sharing options...
Spy Posted July 14, 2008 Report Share Posted July 14, 2008 Wey Hey !!1 RWG is back Well done guys, the improvements sound Fab, can't wait to test drive the fully moded, Pimped up RWG Quote Link to comment Share on other sites More sharing options...
Admin Posted July 14, 2008 Author Report Share Posted July 14, 2008 FYI: there are some backup processes, etc. currently running in the background right now that are rather processor intensive, so it will take a couple of hours until the forum will be up to it's regular speed! Quote Link to comment Share on other sites More sharing options...
StormTooper4 Posted July 14, 2008 Report Share Posted July 14, 2008 Cheers Dude good work and as always appreciated down here ST4 Quote Link to comment Share on other sites More sharing options...
Seadweller4000 Posted July 14, 2008 Report Share Posted July 14, 2008 Great work, thanks T! Quote Link to comment Share on other sites More sharing options...
yellomen Posted July 14, 2008 Report Share Posted July 14, 2008 Thanx T... really appreciated Quote Link to comment Share on other sites More sharing options...
lazarini Posted July 14, 2008 Report Share Posted July 14, 2008 good work T ... appreciated ! Laz Quote Link to comment Share on other sites More sharing options...
Samurai Posted July 14, 2008 Report Share Posted July 14, 2008 Great work. Impressive that the dB is indexed in 10 sec. Out of curiosity....what is the size of the dB and which dB is RWG on? Cheers Quote Link to comment Share on other sites More sharing options...
Stephane Posted July 14, 2008 Report Share Posted July 14, 2008 Thanks T. Quote Link to comment Share on other sites More sharing options...
coolfire Posted July 14, 2008 Report Share Posted July 14, 2008 FYI: there are some backup processes, etc. currently running in the background right now that are rather processor intensive, so it will take a couple of hours until the forum will be up to it's regular speed! Speed seems just as great on my side... T, thanks once again for constantly keeping our forum tiptop... ....So, do we get back our ratings system, now that you've upgraded the processor & RAM?? Quote Link to comment Share on other sites More sharing options...
Admin Posted July 14, 2008 Author Report Share Posted July 14, 2008 ....So, do we get back our ratings system, now that you've upgraded the processor & RAM?? Unfortunately not. Quote Link to comment Share on other sites More sharing options...
Admin Posted July 14, 2008 Author Report Share Posted July 14, 2008 Great work. Impressive that the dB is indexed in 10 sec. Out of curiosity....what is the size of the dB and which dB is RWG on? Cheers The forum DB is just above 1GB. The forum is running on a MySQL database with a combination of InnoDB/MyIsam/Memory(Heap) table types, depending on what the different tables do and how much they are used. But when it comes to the search engine, keep in mind that it only indexes the posts and topic tables. These are about 800MB and I just tested it now, while we seem to have the regular amount of users online. It re-created the post/topic index in 14 seconds. So it's doing a decent job Quote Link to comment Share on other sites More sharing options...
freddy333 Posted July 14, 2008 Report Share Posted July 14, 2008 The site is loading noticeably faster today. Great work & thank you. Quote Link to comment Share on other sites More sharing options...
scoobs1971 Posted July 14, 2008 Report Share Posted July 14, 2008 Thnx, T!! Quote Link to comment Share on other sites More sharing options...
turboGUATE Posted July 14, 2008 Report Share Posted July 14, 2008 Thanks for working on such a great place. Really apreciate it. Cheers! Quote Link to comment Share on other sites More sharing options...
P4GTR Posted July 14, 2008 Report Share Posted July 14, 2008 T, you're swell. Quote Link to comment Share on other sites More sharing options...
chrgod Posted July 14, 2008 Report Share Posted July 14, 2008 Good work, really appreciate your efforts! Quote Link to comment Share on other sites More sharing options...
FxrAndy Posted July 14, 2008 Report Share Posted July 14, 2008 Top bloke! Quote Link to comment Share on other sites More sharing options...
rolli Posted July 14, 2008 Report Share Posted July 14, 2008 considerably better rolli Quote Link to comment Share on other sites More sharing options...
Pugwash Posted July 14, 2008 Report Share Posted July 14, 2008 Two separate processes serving content will provide parallel processing, utilizing our multi-core processors and your browser loads 2 connections faster than 1. Clever gibberish. What you actually mean is you've got the equivalent of two hamsters running through tubes carrying bits of cards. One is carrying pictures, the other is carrying words. Because both hamsters use different habitrails, they don't get caught in a queue behind the slowest hamster. Software/DB optimization (ongoing process) - This is where the biggest focus has been. Server and DB has been optimized. Due to increased computing power, I have added more indexes to the databases, to speed up data fetching. Further utilizing of PHP acceleration. Instead of loading and compiling PHP scripts, the compiled PHP scripts are now cached (kept in the server memory) and serves up pages faster. One word: memcached. Learn it, use it, love it. Quote Link to comment Share on other sites More sharing options...
Admin Posted July 14, 2008 Author Report Share Posted July 14, 2008 What you actually mean is you've got the equivalent of two hamsters running through tubes carrying bits of cards. One is carrying pictures, the other is carrying words. Because both hamsters use different habitrails, they don't get caught in a queue behind the slowest hamster. Well, that's another way of putting it One word: memcached. Learn it, use it, love it. I use eAccelerator on this server. Basically no difference in performance between memcache and eAccelerator with our current setup. On a bigger setup, with more servers and more RAM to use, there's no doubt what I would have used Quote Link to comment Share on other sites More sharing options...
Pugwash Posted July 14, 2008 Report Share Posted July 14, 2008 I use eAccelerator on this server. Basically no difference in performance between memcache and eAccelerator with our current setup. On a bigger setup, with more servers and more RAM to use, there's no doubt what I would have used That's all right then. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.