Home › Forums › Angry Birds 2 Forum › Are the servers down? › Reply To: Are the servers down?
Moderate away, but there are some EASY solutions to this… and I’m not even privy to the server farm layout.
1) Stagger tournament ends. Why must they ALL end at 8 pm Eastern on Saturday? Sure, 3 am is not a good time, nor are times during “working hours” (at least in major countries)…. but try some at 8 pm, some at 9 pm, some at 10 pm…. some on Saturday and some on Sunday.
2) As a database administrator, I SUSPECT the issue is the stored procedure that updates the standings and awards points. SOMEBODY might need to study up on BULK INSERT, or data warehousing / data aggregation techniques.
3) Consider moving to more servers. Yes, that means that a player playing on Server 1 would never be able to play against a player on Servers 2 through N…. but if you have 3X as many isolated (non-replicated) servers, then you gain WAY MORE than 3X performance on huge index rebuilds.
This isn’t rocket science, Rovio…. and apparently it is a known issue. Celebrate your birthday with some upgrades (and bug fixes, and faster technical support turnaround time, too — when I report a bug, it takes you THREE WEEKS just to send out a “yeah, we know”…. and it never gets fixed anyway).
Jester
Reading, PA