01-17-2011, 09:40 PM | #1 |
FFR Hall of Fame
|
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.
__________________
|
01-17-2011, 09:41 PM | #2 |
Party Hard
Join Date: Aug 2006
Posts: 1,310
|
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.
__________________
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) Last edited by flashpantss; 01-17-2011 at 09:53 PM.. |
01-17-2011, 10:11 PM | #3 |
FFR Player
Join Date: Sep 2006
Age: 28
Posts: 91
|
Re: FC / AAA icons
|
01-17-2011, 10:22 PM | #4 |
Doing the wrong thing the right way since 2010.
Site and Game Administrator
Join Date: Jul 2007
Posts: 1,813
|
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.
|
01-17-2011, 10:26 PM | #5 |
FFR Hall of Fame
|
Re: FC / AAA icons
Indeed like many other things in FFR there are two different files that do the Same Exact Thing!!!
__________________
|
01-17-2011, 10:59 PM | #6 |
Doing the wrong thing the right way since 2010.
Site and Game Administrator
Join Date: Jul 2007
Posts: 1,813
|
Re: FC / AAA icons
|
01-17-2011, 11:23 PM | #7 |
FFR Player
Join Date: Aug 2007
Age: 31
Posts: 8,548
|
Re: FC / AAA icons
Rofl Jon VS AP who would win.
|
01-17-2011, 11:32 PM | #8 |
FFR Hall of Fame
|
Re: FC / AAA icons
Velocity doesn't have cool graphs.
Guess when I turned off those icons...
__________________
|
01-18-2011, 01:53 AM | #9 |
Everlong
Join Date: Dec 2004
Location: Madison, Wisconsin
Age: 35
Posts: 3,833
|
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. |
01-18-2011, 02:58 AM | #10 |
FFR Player
Join Date: Aug 2007
Age: 31
Posts: 8,548
|
Re: FC / AAA icons
Bleh graphs are overrated like all math things
|
01-18-2011, 07:20 AM | #11 |
FFR Player
Join Date: Sep 2006
Age: 28
Posts: 91
|
Re: FC / AAA icons
Are they ever going to be turned back on?
|
01-18-2011, 08:06 AM | #12 |
I like max
Join Date: Feb 2007
Location: Vancouver/Burnaby/East Van
Age: 30
Posts: 2,921
|
Re: FC / AAA icons
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 |
01-18-2011, 09:29 AM | #13 |
FFR Player
Join Date: Sep 2006
Age: 28
Posts: 91
|
Re: FC / AAA icons
Oh.
|
01-18-2011, 10:35 AM | #14 |
Snek
Join Date: Jan 2003
Location: Kansas
Age: 34
Posts: 9,192
|
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. |
01-18-2011, 02:35 PM | #15 |
FFR Player
Join Date: Jan 2011
Posts: 10
|
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 |
01-18-2011, 02:58 PM | #16 | |
FFR Hall of Fame
|
Re: FC / AAA icons
Quote:
__________________
|
|
01-18-2011, 03:15 PM | #17 | |
Rhythm game specialist.
|
Re: FC / AAA icons
Quote:
Nice find, as usual. Pretty nuts that something this simple could lead to so many problems. |
|
01-19-2011, 06:59 PM | #18 |
Doing the wrong thing the right way since 2010.
Site and Game Administrator
Join Date: Jul 2007
Posts: 1,813
|
Re: FC / AAA icons
When I manage to port my engine code over, the FC/AAA icons will work, sort by Rank will exist, and the icons will work forever, not just older songs.
|
01-20-2011, 11:59 AM | #19 |
FFR Veteran
Join Date: Nov 2006
Posts: 16
|
Re: FC / AAA icons
yey, thanks for all your work guys!
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|