BuzzerBeater Forums

Thanks for the explanation. I hope you'll soon find a way to manage your processing power in a better way (or just find more processing power). Maybe with ideas like JoeMaverick's one. But of course - we don't know how much funds you have at the moment to just "buy another server".

On thursdays, it takes less because there are a lot less cup games. This explanation was given before.
And this was suggested before, if the problem comes from the large number of games then cut it down.

In the French league, currently, the cup has 13 rounds.
Round 1 has 8128 teams and 4064 games.
Boxscores always show up instantly in France and in neighbouring countries.


The league structure is as follow :
16 teams in Pro A
64 in D.II
256 in D.III
1024 in D.IV
4096 in D.V
16384 in D.VI

Total number of teams : 21820 (10910 games per game day)
Of which 2462 active teams !
I've just checked the number and I am genuinely shocked. Less active teams than when I joined :(


D.VI is all-bot.
Many dead leagues around the BB world are all-bot.

Can we go back to the situation before the creation of these leagues ? They are fairly recent.

D.I to D.V = 2728 league games
D.VI alone = 10910 league games, 100% bot

If bot-team games aren't as processing intensive than human-team games then don't claim that it's smoother on cup days because there are less games, the number of games a human-team is involved is actually larger in the first rounds than on league days.
If the problem is the number of games, please cut, drop or "freeze" all these dead, ghost leagues.
It might be a difficult decision, a decision for the big boss.
It looks and has always looked like a realistic solution technically.

Boxscores on league days aren't working properly for 3 years.

...edit for shorter version and such...





Last edited by Manouche at 10/30/2012 4:24:37 AM

Your reasoning is solid, but I have to explain a little more. I may have been using a wrong word. "Processing" sounds too much like only CPU calculations, while I meant it as a whole, CPU calculations, reading of the data and writing the data back to the database too. That part, the SQL database input/output is what takes the longest by far. So, copying the data to another server would not actually help since it would still need to read and write the same data, just like it does now.

Also, because this is a live site, to copy the data and then write it back, we'd have to be sure nothing changed it in the meantime. That itself would be almost impossible due to the volume of the code.

the game calculations take datas from SQL/Oracle tables and as result, they fill in another tables.

They often do that, but also they update the same tables they read from.

Oops!
Something went wrong with your request. The error has automatically been logged and reported to BuzzerBeater developers. Some errors go away when you hit the back button and try again. If you continue to get an error, you can post about it in the bugs forum.
On the new site, the most common reason for this error is because you were trying to access a page that assumed you were logged in when in fact you were not (probably becuase your session timed out). So simply logging in and trying again might solve your problem. We are working on fixing this more elegantly.

On thursdays, it takes less because there are a lot less cup games. This explanation was given before.
And this was suggested before, if the problem comes from the large number of games then cut it down.

In the French league, currently, the cup has 13 rounds.
Round 1 has 8128 teams and 4064 games.
Boxscores always show up instantly in France and in neighbouring countries.


The league structure is as follow :
16 teams in Pro A
64 in D.II
256 in D.III
1024 in D.IV
4096 in D.V
16384 in D.VI

Total number of teams : 21820 (10910 games per game day)
Of which 2462 active teams !
I've just checked the number and I am genuinely shocked. Less active teams than when I joined


D.VI is all-bot.
Many dead leagues around the BB world are all-bot.

Can we go back to the situation before the creation of these leagues ? They are fairly recent.

D.I to D.V = 2728 league games
D.VI alone = 10910 league games, 100% bot

If bot-team games aren't as processing intensive than human-team games then don't claim that it's smoother on cup days because there are less games, the number of games a human-team is involved is actually larger in the first rounds than on league days.
If the problem is the number of games, please cut, drop or "freeze" all these dead, ghost leagues.
It might be a difficult decision, a decision for the big boss.
It looks and has always looked like a realistic solution technically.

Boxscores on league days aren't working properly for 3 years.

...edit for shorter version and such...

the man has a point.


im not sure if its because daylight savings, but delays in my country were about 2 hours, instead of 4-5

Last edited by Boston Celts at 10/30/2012 3:32:51 PM

Yeah, we use indexes, not to worry. I have to say, your way would maybe make sense in a different setting. Currently, I don't see how this could improve performance at all, since you'd still need to read and write the same data in the end. What you do in the middle doesn't help.

Believe me, we've had Charles and Forrest looking at this problem a couple of times, and if they couldn't figure out a better way, it's probably not there. Doesn't mean we'll stop looking for it though.

Yeah, but reading and writing have to be done either way. It's not the calculations that are slow, it's the I/O.

To get the data to the second server, you still need to read it from somewhere, right?

It's worth looking into. I'll try to pick the brains of our senior devs about it and see what they think. Thanks for the input.