Current Song Stats and a peek.

[AlexDest]

Re: Current Song Stats and a peek.

[African Anger]

Re: Current Song Stats and a peek.

I'm not sure internet speed has anything to do with this.


Then again, my speed is poop

it sure doesn't

[Velocity]

Re: Current Song Stats and a peek.

Copyright Flash Flash Revolution 2002-2014 (loaded in 0.788 seconds) v3.0

There's several things that can be sped up, but I'll look into that after the release. Right now I believe it may be sorting related which is handled in js now.

[tosh]

Re: Current Song Stats and a peek.

Yeah the levelrank page has always loaded like 15x slower than every other page on the site for me.

[Velocity]

Re: Current Song Stats and a peek.

There's 2 major factors involved. The amount of songs and getting the ranks.
For each song, it has to get the amount of players who did better then you, or if you haven't played, the total amount of users. After that it gets the songs arrow count and determines AAA/FC other things.

After all that is done, it sorts it by rank, which php handles quite slowly.


So in total:

+1 SQL: Get note count, name, id for all levels.

Loop #1 (Every Level) {
	+1 SQL: Get Player Rank
	Determine AAA/FC
}

Determine Token Unlocks
Sort on Rank

Loop #2 (Every sorted level) {
	Display
}

aka, old system is slow.

[shenjoku]

Re: Current Song Stats and a peek.

Wow, this stuff looks pretty crazy. Looking forward to it

[justin_ator]

Re: Current Song Stats and a peek.

There's 2 major factors involved. The amount of songs and getting the ranks.
For each song, it has to get the amount of players who did better then you, or if you haven't played, the total amount of users. After that it gets the songs arrow count and determines AAA/FC other things.

After all that is done, it sorts it by rank, which php handles quite slowly.


So in total:

+1 SQL: Get note count, name, id for all levels.

Loop #1 (Every Level) {
	+1 SQL: Get Player Rank
	Determine AAA/FC
}

Determine Token Unlocks
Sort on Rank

Loop #2 (Every sorted level) {
	Display
}

aka, old system is slow.

Makes sense at least. It really is the only page that has some sort of load time for me on the site.

[Razor]

Re: Current Song Stats and a peek.

or maybe its cause half of you have toasters for computers

[Pseudo Enigma]

Re: Current Song Stats and a peek.

I'm pretty sure a toaster can still perfectly process a loop like that one though??? Anyway it doesn't matter, it's still an inconvenience.

[Velocity]

Re: Current Song Stats and a peek.

If yall could stop caring about stats then there wouldn't be a problem. As it were, I said previously that it should be fixed, but since mine loads instantly anyway, it's hard to tell.

[rushyrulz]

Re: Current Song Stats and a peek.

integrate this

http://www.flashflashrevolution.com/vbz/showthread.php?t=133128

I know it's prolly not gonna happen.

[ExacerbatE]

Re: Current Song Stats and a peek.

integrate this

http://www.flashflashrevolution.com/vbz/showthread.php?t=133128

I know it's prolly not gonna happen.

That would be cool though.

[Velocity]

Re: Current Song Stats and a peek.

integrate this

http://www.flashflashrevolution.com/vbz/showthread.php?t=133128

I know it's prolly not gonna happen.

src plz. I'm lazy.

[ExacerbatE]

Re: Current Song Stats and a peek.



Just because I didn't do it and felt kinda bored...

[Velocity]

Re: Current Song Stats and a peek.

integrate this

http://www.flashflashrevolution.com/vbz/showthread.php?t=133128

I know it's prolly not gonna happen.

Edit: finished.