BingoGems.co.uk Menu
2011
Aug
10

Best Players Lists

Categories: Bingo Game Server, Flash Bingo Games, Site Updates

I was shooting for an August 1st launch date, and I was actually on track, however as I have mentioned in the last post I was concerned about some potential speed issues regarding best player lists. The best way to test this is by doing actual profiling, however since there are still no large volume of existing data, I have to make some codes to create hundreds of thousands of test data. This puts the test data on par with HB’s current database size, if not even larger.

And my hunch was right. The tables and codes just aren’t fast enough. This is because I opted to implement real-time display of best player lists. This means as soon as a game is over, you can immediately see the stats updated from any page, or within the Flash bingo games. In contrast, HB updates these same stats once every 24 hours only.

So I decided to just delay the launch date (again), so I can work on optimizing this problem area. This involves making use of secondary tables and further optimizing current table indices and queries, in order to speed up read access of the affected tables. Unfortunately, this required code changes in all areas (web site, bingo game servers, Flash bingo games), hence it took me a couple of days to wrap up everything including a new set of necessary tests.

It took a lot of work, but I am more at ease now knowing that even a few years from now, the current setup can still reliably handle a larger volume of players and data. Real-time reporting of stats is still fully supported, which is really what I wanted from the start.

There were also some other changes/updates in other areas:

  • Fixed a bug that doesn’t parse the bingo room name properly (happens on IE browsers only).
  • Fixed a Flash alignment bug which may disrupt the display (happens on IE 9 only). Unfortunately, this looks like a known unfixed bug on IE 9 itself, so I’ve only done a possible workaround to make the display bug less obvious.
  • There are times when the chat history is being messed up. I think it happens when the chat text is being pruned. I haven’t been able to reproduce the bug yet. I’ve done some potential fixes, but it’s possible this issue may reappear in the future.
  • Fixed bug where the initial value of the minimum jackpot amount was not being properly set.
  • Changed order of pot/jackpot displays.

All the changes (in all areas) are now active. Just doing some more tests right now.

Tags: ,

Search Blog