FC / AAA icons

**aperson** · 01-17-2011, 09:40 PM

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.

**flashpantss** · 01-17-2011, 09:41 PM

That stinks that takes up up to 70% of the server. hopefully, the new program will do the trick.
BTW, Aperson rules.

666midget · 01-17-2011, 10:11 PM

Quote:

Originally Posted by flashpantss

BTW, Aperson rules.

No question about it.

**Velocity** · 01-17-2011, 10:22 PM

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

**aperson** · 01-17-2011, 10:26 PM

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

**Velocity** · 01-17-2011, 10:59 PM

Quote:

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.

Xx{Midnight}xX · 01-17-2011, 11:23 PM

Rofl Jon VS AP who would win.

**aperson** · 01-17-2011, 11:32 PM

Quote:

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...

**HammyMcSquirrel** · 01-18-2011, 01:53 AM

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.

Xx{Midnight}xX · 01-18-2011, 02:58 AM

Bleh graphs are overrated like all math things

666midget · 01-18-2011, 07:20 AM

Are they ever going to be turned back on?

**25thhour** · 01-18-2011, 08:06 AM

Quote:

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.

666midget · 01-18-2011, 09:29 AM

Izzy · 01-18-2011, 10:35 AM

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.

bdev1 · 01-18-2011, 02:35 PM

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

**aperson** · 01-18-2011, 02:58 PM

Quote:

Originally Posted by bdev1

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

That's what Velocity is incorporating into the engine. Most of the reason it's causing problems is in the Flash code.

**TC_Halogen** · 01-18-2011, 03:15 PM

Quote:

Originally Posted by aperson

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.

...

Nice find, as usual. Pretty nuts that something this simple could lead to so many problems.

**Velocity** · 01-19-2011, 06:59 PM

Quote:

Originally Posted by aperson

That's what Velocity is incorporating into the engine. Most of the reason it's causing problems is in the Flash code.

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.

**Strikingvipr** · 01-20-2011, 11:59 AM

yey, thanks for all your work guys!

01-17-2011, 09:40 PM	#1
aperson FFR Hall of Fame Join Date: Jul 2003 Location: Houston Posts: 3,428	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
flashpantss 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:22 PM	#4
Velocity Doing the wrong thing the right way since 2010. Site and Game Administrator Join Date: Jul 2007 Posts: 1,812	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
aperson FFR Hall of Fame Join Date: Jul 2003 Location: Houston Posts: 3,428	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, 11:23 PM	#7
Xx{Midnight}xX FFR Player Join Date: Aug 2007 Age: 31 Posts: 8,548	Re: FC / AAA icons Rofl Jon VS AP who would win.

01-18-2011, 01:53 AM	#9
HammyMcSquirrel 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
Xx{Midnight}xX 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, 10:35 AM	#14
Izzy 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
bdev1 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-20-2011, 11:59 AM	#19
Strikingvipr 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)