Game Programming - Databases

[Return 0]

I'm preparing to take the next step in my project and would like some feedback on what type/form of database would be appropriate and simply fast enough to handle a load of say 100,000 players, but scalable enough to handle millions. My focus for now is trying to select the appropriate database for an MMO game. Any ideas what might be the fastest, most secure selection?

My current plans are to stick with SQL Server, but I'm just not sure if it's up to the task of an MMO. For Business apps, no problem, but can it handle millions of transactions without lag???

Thanks,
Return 0;

[S6k9GNh0]

You might need to make a queu. And you won't recieve millions of transactions at once. You will probably recieve a couple thousand every hour or so and you will have to deal with the occasional brute force, DoS attacks, etc. which can be prevented in the first place.

For more of an example, try looking around or maybe GameDev can help you out.

http://gamedev.net

[helios]

DoS attacks

Those occur at the network level (e.g. by massively pinging the server). Never heard of a DoS aimed at grinding the database response to a halt. Then again, I mostly hear about general purpose DDoS.

[S6k9GNh0]

DoS can slow everything down though, from internet to taking up processing speed. Just taking into account.