FC / AAA icons

Collapse
X
Collapse
 
  • Page of 2
  • Time
  • Show
Clear All
new posts
Previous 1 2 template Next
  • aperson
    FFR Hall of Fame
    FFR Simfile Author
    • Jul 2003
    • 3431
    #1

    FC / AAA icons

    I recently put some new benchmarking utilities on the server that make it easier to see what is causing the most database load.

    As it turns out, these query your stats to find out which song you are in. Then each time they query EVERY SINGLE LEVEL YOU HAVE PLAYED and then do score arithmetic to see if you have a FC or AAA on that song.

    The file that calculates this, by itself, is responsible for over half of the queries going into the server and is singlehandedly killing the query cache. It is responsible for anywhere between 10 to 70% of the server load at any given time. As such, I have disabled it until I can write a better system to calculate these.

    Tags: None
    • flashpantss
      Party Hard
      • Aug 2006
      • 1310
      #2
      Re: FC / AAA icons

      That stinks that takes up up to 70% of the server. hopefully, the new program will do the trick.
      BTW, Aperson rules.
      Last edited by flashpantss; 01-17-2011, 08:53 PM.
      10th in 5th Official Tournament in D3
      3RD in Dragons Fury: Custom Tournament #5 in D5A
      Best AAA's= Frictional Nevada (FIRST FGO) Kyrie (ONI Get), Eradication, Of Course you Need and nEed and neEd and NEED ME, Cinnamon Roll (FIRST TO AAA)

        Comment

        • 666midget
          FFR Player
          • Sep 2006
          • 91
          #3
          Re: FC / AAA icons

          Originally posted by flashpantss
          BTW, Aperson rules.
          No question about it.

          Originally posted by MrGiggles
          males are the master gender because we have mastered the ability to pee on/in various objects with various techniques

          women are at least several thousand years behind in peeing technology

          they don't even have penises yet, LOL

            Comment

            • Velocity
              Doing the wrong thing the right way since 2010.
              FFR Simfile Author
              FFR Administrator
              • Jul 2007
              • 1817
              #4
              Re: FC / AAA icons

              Should be noted that this doesn't affect the scores/rank sort in Velocity engine as that deals with another file.

                Comment

                • aperson
                  FFR Hall of Fame
                  FFR Simfile Author
                  • Jul 2003
                  • 3431
                  #5
                  Re: FC / AAA icons

                  Indeed like many other things in FFR there are two different files that do the Same Exact Thing!!!

                    Comment

                    • Velocity
                      Doing the wrong thing the right way since 2010.
                      FFR Simfile Author
                      FFR Administrator
                      • Jul 2007
                      • 1817
                      #6
                      Re: FC / AAA icons

                      Originally posted by aperson
                      Indeed like many other things in FFR there are two different files that do the Same Exact Thing!!!
                      Only one's done right, and the other done wrong.

                        Comment

                        • Xx{Midnight}xX
                          FFR Player
                          • Aug 2007
                          • 8548
                          #7
                          Re: FC / AAA icons

                          Rofl Jon VS AP who would win.

                            Comment

                            • aperson
                              FFR Hall of Fame
                              FFR Simfile Author
                              • Jul 2003
                              • 3431
                              #8
                              Re: FC / AAA icons

                              Originally posted by Xx{Midnight}xX
                              Rofl Jon VS AP who would win.
                              Velocity doesn't have cool graphs.


                              Guess when I turned off those icons...

                                Comment

                                • HammyMcSquirrel
                                  Everlong
                                  FFR Simfile Author
                                  FFR Music Producer
                                  • Dec 2004
                                  • 3833
                                  #9
                                  Re: FC / AAA icons

                                  Since there are already people posting in other topics about this, I'll make this thread a sticky until the whole issue has been resolved.

                                  Thanks for all of the work you're doing, aperson.

                                    Comment

                                    • Xx{Midnight}xX
                                      FFR Player
                                      • Aug 2007
                                      • 8548
                                      #10
                                      Re: FC / AAA icons

                                      Bleh graphs are overrated like all math things

                                        Comment

                                        • 666midget
                                          FFR Player
                                          • Sep 2006
                                          • 91
                                          #11
                                          Re: FC / AAA icons

                                          Are they ever going to be turned back on?

                                          Originally posted by MrGiggles
                                          males are the master gender because we have mastered the ability to pee on/in various objects with various techniques

                                          women are at least several thousand years behind in peeing technology

                                          they don't even have penises yet, LOL

                                            Comment

                                            • 25thhour
                                              I like max
                                              • Feb 2007
                                              • 2922
                                              #12
                                              Re: FC / AAA icons

                                              Originally posted by 666midget
                                              Are they ever going to be turned back on?
                                              AP said he was going to code a new system for it.
                                              r bae adam bae max bae bridget bae claudia bae trevor bae adam2 bae mayo bae keith bae

                                                Comment

                                                • 666midget
                                                  FFR Player
                                                  • Sep 2006
                                                  • 91
                                                  #13
                                                  Re: FC / AAA icons

                                                  Oh.

                                                  Originally posted by MrGiggles
                                                  males are the master gender because we have mastered the ability to pee on/in various objects with various techniques

                                                  women are at least several thousand years behind in peeing technology

                                                  they don't even have penises yet, LOL

                                                    Comment

                                                    • Izzy
                                                      Snek
                                                      FFR Simfile Author
                                                      • Jan 2003
                                                      • 9195
                                                      #14
                                                      Re: FC / AAA icons

                                                      Create a button that allows you to manually update the AAA/FC icons so that it isn't constantly sending queries automatically. Or have it only update at midnight or something.

                                                      Edit: nvm, the midnight thing wouldn't work.

                                                        Comment

                                                        • bdev1
                                                          FFR Player
                                                          • Jan 2011
                                                          • 10
                                                          #15
                                                          Re: FC / AAA icons

                                                          have it query only once when you open the game instead of after every song? that would reduce it alot, i just dont know to much about how the rest of everything works lol

                                                          i was about to come on here and search for why they werent popping up, good thing this got stickied and i dont have to worry haha

                                                            Comment

                                                            Previous 1 2 template Next
                                                            Working...