BuzzerBeater Forums

Bugs, bugs, bugs > Box Score

Box Score

Set priority
Show messages by
This Post:
00
227382.12 in reply to 227382.9
Date: 10/30/2012 9:34:55 AM
TrenseRI
II.1
Overall Posts Rated:
36063606
Second Team:
ChiLeaders
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.

From: Hadar
This Post:
00
227382.14 in reply to 227382.13
Date: 10/30/2012 3:14:30 PM
Overall Posts Rated:
375375

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.

This Post:
11
227382.15 in reply to 227382.11
Date: 10/30/2012 3:27:07 PM
Overall Posts Rated:
345345
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

This Post:
00
227382.16 in reply to 227382.13
Date: 10/31/2012 8:52:52 AM
TrenseRI
II.1
Overall Posts Rated:
36063606
Second Team:
ChiLeaders
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.

This Post:
00
227382.18 in reply to 227382.17
Date: 10/31/2012 10:10:25 AM
TrenseRI
II.1
Overall Posts Rated:
36063606
Second Team:
ChiLeaders
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?

This Post:
00
227382.20 in reply to 227382.19
Date: 10/31/2012 11:07:47 AM
TrenseRI
II.1
Overall Posts Rated:
36063606
Second Team:
ChiLeaders
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.

This Post:
00
227382.22 in reply to 227382.19
Date: 10/31/2012 4:29:03 PM
Overall Posts Rated:
32293229
To get the data to the second server, you still need to read it from somewhere, right?

Yes, that's right and here it's important to know how your two servers can communicate to each other. Here are my limitations. But, with Microsoft SQL server (I think that exists for oracle too), you can create a "linked server" object. If you succeed to create a linked server on the two SQL servers, you will be able to make SQL statements from one server to the other one like this:

insert server1.db_name.dbo.table_name (col1, col2,..., coln) select col1, col2,..., coln from server2.db_name.dbo.table_name

That means you could copy all the needed datas with very simple SQL statements. And the nice thing is that, even if you have million of records in your tables, these statements will be very, fast (some seconds).

I know how to create linked server on SQL Server Management Studio, but that supposes that the two servers are able to communicate to each other (same domain?). And here is the end of daily job. But you have many information about that on the net ;)

PS: just to be sure, a linked server is a SQL object which is created in a SQL Server which is installed on a server (hardware). Because there are too many "server" in this message :p


For pulling the data over, there's also replication which can work (well, in addition to mirroring, but that's primarily most effective for failover support). But if they're reading and then updating the same table, unless they could ensure that nothing else touched that table during the time it would take to process the box scores, I don't think relocating the data to another server would help. (Though as a programmer who is administering some databases but not a DBA, I freely admit I might be missing something relevant.)

I would think this scenario may instead be a case where DB redesign could be more effective, though of course that is not something to be undertaken lightly at all. Naturally, one could also scream "more hardware" and if the server were not using SSDs or enough RAM, that could be a consideration, but cost benefit issues arise there.

Advertisement