Call me crazy, call me stupid. I’m preparing a project where I will simulate the possible behaviour of the Steam database as an ASP.NET MVC solution. My goal is to prove that it could be possible to have a database as large as the Steam database with a similar payload and still have an adequate community API which doesn’t sacrifice flexibility, comfort and data delivery for performance savings. I understand this project more than a prototype for the Steam Community API and therefore will focus completely on a redesigned web service interface and its according data layer.
Of course I won’t be able to really simulate the usual payload which the Steam servers are fighting with and that’s really not important. I will be able to simulate an adequate payload and scale it to simulate something like a daily server load.
With the above information and the idea to get the best out of the prototype I will design the prototype with the following figures in mind assuming that the numbers represent the most realistic scenario possible:
- amount of registered users in database: 35.000.000 users
- amount of games in database: 20.000 games
- avg amount of users online: 5.000.000 users/online
- avg amount of games per user: 1000 games/user
- avg amount of friends per user: 500 friends/user
- avg amount of items in inventory: 100 items/inventory
some of these figures are just estimated but they are totally OK for our prototype and the test we will run to measure performance and behaviour of our Steam Web API.
As I said above this prototype will be developed in ASP.NET MVC making use of Web API as the service endpoint. While I’m already working on the database and the application design I’m curious what you guys think about this project. Will I be able to achieve my goal and prove that even databases that large are able to provide a decent API which stills performs under a usual or even heavy database payload?
Any comments, suggestions, critics are welcome.
It has been a while since my last toplist. Now that the year 2013 ends I took the time to write about my personal best games in year 2013. It was a really great year when it comes to game releases so it was pretty hard to pick my favorites but I think the list below shows the best PC releases of this year.
Continue reading “Toplist – Greatest games of 2013” »
I tried to install XNA recently on my new Windows 8 notebook to continue some old work and run immediately into problems. So what exactly did not work? When trying to install the Windows Phone dev tools where XNA is part of the installation fails. The issue is discussed in detail here: http://blogs.msdn.com/b/astebner/archive/2012/02/29/10274694.aspx
Continue reading “Visual Studio 2010 and XNA on Windows 8” »
Indie is in. More than ever. It’s chick, just because it’s different. the most amazing genre, the most interesting people. Here are some of in my opinion greatest indie titles. Games that had more content, gameplay and depth than AAA titles, games that made me destroy one controller, two keyboards, one mouse and a ruler. Back to the toplist. This isn’t a real toplist since I wont’t give a rank or rating. All of the below games are awesome in their own way.
Continue reading “Toplist – 12 great indie games” »
I use Subversion as a versioning system for all my projects, no matter if web application, game, phone app. It works great and has everything I need and much more. I personally use the AnkhSVN plugin for Visual Studio integration. It’s a great plugin and the only thing I can Name as a contra is that you Need additional merge and diff tools. But thats all. You can specify nearly every popular merge and diff tool in the options menu of Visual Studio, so don’t worry about that. I’m usually a friend of complete solutions so I was looking for more alternatives which would be more complete than AnkhSVN but couldn’t find one with that good VS integration.
Continue reading “Subversion and Visual Studio” »
If you are reading this you most probably are already on the new site with the new blog and the new url. Please update your bookmarks. My blog will be accessible only through www.dim-i.net
I checked if everything is correct and it seems the transfer worked flawlessly. If you encounter any broken links, please let me know.
There seems to be some confusion about the profile in the settings menu. Some users report they enter their profile name and cannot retrieve any data. As soon as I’m back I’ll provide an update which will fix this issue. In fact it is not a bug but most probably a misunderstanding of the term steam profile.
Continue reading “SteamCenter profile misunderstanding” »