1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Issues you will notice this morning

Discussion in 'Rugby League Forum' started by Dan, Apr 23, 2010.

  1. Dan

    Dan Administrator Staff Member Administrator 2016 Tipping Competitor

    32,371
    3,610
    Amsterdam, The Netherlands
    Ratings:
    +5,466 / 74
    I spent a great many hours last night tuning the forums a little, in fac tit is 1am as I write this and I have to be up for work in another 5 hours and i am not finished yet :(

    Anyway you will notice that all forum posts are marked as new again. I had to do this as I converted a lot of post tables to InnoDB and needed to cut as much superfluous data as i could to speed up the process. As such the storage for the "post read" information was cleared and the tables altered. If you mark the forums as read again (link at the bottom of each forum) you will again return to normal.

    I have also rebuilt the Search Index which I neglected to do a long time ago and as such has taken some time. This will speed up searches and remove some overheads.

    You will also be missing your avatars. I have removed remote avatars and changed the upload method so they are now loaded locally instead of further PHP and mysql calls.

    I am pretty much at the absolute limit of the Tuning I can do with PHP and MYSQL with the forums and now have to go back and revisit a lot of my code for things like the news and tipping etc and bring those queries down. I will also look at merging a lot of CSS and JS. This should also bring down a few overheads and http requests there fore speeding up each page load on the forums and front page.

    I will continue to do profiling over the next few weeks and try to speed the site up as much as possible as it has gradually gotten slower and slower over the past few months for various reasons. We also have a fair bit of data in the site itself which also doesn't help.

    I will also start testing some new forum software, both IPB and Vbulletin, both come at a cost of between $145 and $200 USD but I think that purchase will be worth it if it enhances the overall site and it's speed. The general plan will be some fresh installs of the forums and the website and then merging over the data.

    It's a long process but in order for us to keep the site loading in reasonable times it is something we will have to do.

    Cheers
    Dan
     
  2. Dan

    Dan Administrator Staff Member Administrator 2016 Tipping Competitor

    32,371
    3,610
    Amsterdam, The Netherlands
    Ratings:
    +5,466 / 74
    Oh, you will also see the forums in a white colour without the site around them. That is because of the index rebuild I cant stay up waiting for it to finish, as it is only 40% complete so will go to bed and fix the template first thing in the morning
     
  3. Jethro

    Jethro This space is for rent Staff Member Premium Member 2016 Tipping Competitor

    7,128
    1,492
    Ratings:
    +1,897 / 7
    Hey Dan, I don't know if I have misread what you have written but with the removal of our personal avatars, will this be only a temporary thing as I have tried to upload my avatar again to the site so that it can be used locally but it won't show (only the default avatars are listed).

    Cheers
     
  4. Dan

    Dan Administrator Staff Member Administrator 2016 Tipping Competitor

    32,371
    3,610
    Amsterdam, The Netherlands
    Ratings:
    +5,466 / 74
    will have to have a look at that for you today. I had to remove them to speed it up and change directories so it could be that the setting is wrong but will double check soon
     
  5. Zep

    Zep Active Member

    1,692
    8
    Ratings:
    +8 / 0
    Nice work dan, i can notice the difference already.
     
  6. Dan

    Dan Administrator Staff Member Administrator 2016 Tipping Competitor

    32,371
    3,610
    Amsterdam, The Netherlands
    Ratings:
    +5,466 / 74
    not sure what will happen when I re-wrap the forums back inside the site though.

    Still more tweaking going on too
     
  7. Berkeley_Eagle

    Berkeley_Eagle Current Status: 24/7 Manly Fan 2016 Tipping Competitor

    15,995
    1,849
    Ratings:
    +2,115 / 14
  8. Dan

    Dan Administrator Staff Member Administrator 2016 Tipping Competitor

    32,371
    3,610
    Amsterdam, The Netherlands
    Ratings:
    +5,466 / 74
    should be a little more back to normal now. just got to get avatars back
     
  9. nita

    nita Member

    425
    2
    Ratings:
    +2 / 0
    thanks for your hard work :)
     
  10. Jethro

    Jethro This space is for rent Staff Member Premium Member 2016 Tipping Competitor

    7,128
    1,492
    Ratings:
    +1,897 / 7
  11. ads

    ads Well-Known Member

    1,633
    26
    Ratings:
    +28 / 1
    Personally I love this site and having looked after websites before I understand how much work it is and how frustrating it can be.

    So a big thanks from me for all your hard work!
     
  12. Chip and Chase

    Chip and Chase True Supporter Staff Member Administrator Premium Member 2016 Tipping Competitor

    12,810
    3,170
    Ratings:
    +6,282 / 44
    You lost me at "I spent", but keep up the good work champ.
     

Share This Page