Forum Optimizations

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • aperson
    FFR Hall of Fame
    FFR Simfile Author
    • Jul 2003
    • 3431

    #1

    Forum Optimizations

    I made some optimizations to the VBulletin code that handles how the forums are displayed. Everything should be loading a fair bit more quickly now. Let me know if you run into any issues on the forums.

  • who_cares973
    FFR Player
    • Aug 2006
    • 15407

    #2
    Re: Forum Optimizations

    more like lightning fast

    Comment

    • nois-or-e
      SponCon Aficionado
      FFR Simfile Author
      • Mar 2007
      • 3250

      #3
      Re: Forum Optimizations

      o/

      Comment

      • Coolboyrulez0
        VICES
        FFR Simfile Author
        FFR Music Producer
        • Aug 2006
        • 10042

        #4
        Re: Forum Optimizations

        ap is the man 8)
        https://soundcloud.com/cbrbreakcore
        https://cbrrecords.bandcamp.com/

        Comment

        • ghost-
          Banned
          • Dec 2010
          • 787

          #5
          Re: Forum Optimizations

          I have a little more respect for you now aperson. Not that my respect should have any impact on you whatsoever, I just wanted to let you know.

          Comment

          • TC_Halogen
            Rhythm game specialist.
            FFR Simfile Author
            FFR Music Producer
            • Feb 2008
            • 19376

            #6
            Re: Forum Optimizations

            They're definitely faster on my end. What exactly did you do?

            Comment

            • One Winged Angel
              Anime Avatars ( ◜◡^)っ✂╰⋃╯
              FFR Simfile Author
              • Mar 2007
              • 10837

              #7
              Re: Forum Optimizations

              mad fast for me, and that's with my terrible mcmaster internet connection right now

              you're the man, ap


              Originally posted by ilikexd
              i want to be cucked by cirno

              Comment

              • kmay
                Don't forget me
                • Jan 2007
                • 6511

                #8
                Re: Forum Optimizations

                yea posting is a **** ton faster

                Comment

                • TC_Halogen
                  Rhythm game specialist.
                  FFR Simfile Author
                  FFR Music Producer
                  • Feb 2008
                  • 19376

                  #9
                  Re: Forum Optimizations

                  I agree - the most noticeable improvement is the time it takes for a post to appear on the page; you don't have to wait 5+ seconds for the post to show up in the thread, it shows up immediately.

                  Comment

                  • aperson
                    FFR Hall of Fame
                    FFR Simfile Author
                    • Jul 2003
                    • 3431

                    #10
                    Re: Forum Optimizations

                    Originally posted by TC_Halogen
                    They're definitely faster on my end. What exactly did you do?
                    A lot of the queries that retrieve the latest updated posts, like the queries to display the last post on each forum in the index, were running really slowly because MySQL's query optimizer was fudging around and choosing the wrong index a lot of the time. I set all of those queries to be forced to use the right index and it turned all of these queries that have about a 0.5s average time to a 0.005s average time.

                    Comment

                    • cedolad
                      moonchild~
                      FFR Simfile Author
                      • Jan 2007
                      • 6879

                      #11
                      Re: Forum Optimizations

                      I don't think I noticed it until I read this.

                      Comment

                      • cry4eternity
                        ~ added for cuteness
                        FFR Simfile Author
                        • Jan 2007
                        • 979

                        #12
                        Re: Forum Optimizations

                        Click on person's name --> FFR profile

                        No more stupid forum profiles as the first option . Who uses those anyway?

                        I'm retired

                        Comment

                        • customstuff
                          ♥C.S. + A.M.♥
                          • Nov 2006
                          • 4892

                          #13
                          Re: Forum Optimizations

                          Testing...

                          Edit: The difference for me is quite minor, but I can tell that it has improved. Nice job AP

                          Originally posted by MrMagic5239
                          Placements are final, custom will not be moved to D6, just because he is good at jacks, and mediocre at just about every other FMO in the game.
                          Originally posted by customstuff
                          Originally posted by MrMagic5239
                          welcome to D6

                          start playing

                          Comment

                          • aperson
                            FFR Hall of Fame
                            FFR Simfile Author
                            • Jul 2003
                            • 3431

                            #14
                            Re: Forum Optimizations

                            Originally posted by cry4eternity
                            Click on person's name --> FFR profile

                            No more stupid forum profiles as the first option . Who uses those anyway?
                            It's on my list to rip those out of vbulletin.

                            Comment

                            • aperson
                              FFR Hall of Fame
                              FFR Simfile Author
                              • Jul 2003
                              • 3431

                              #15
                              Re: Forum Optimizations

                              It looks like a lot of the slowness now is caused by profile queries.

                              Off to tidy up profiles~~~

                              Comment

                              Working...