During the end phase
of the second alpha test, one of the players informed me that logging in to the game took about 10 seconds for him.
The reason for this
lied in a sql query which performed bad.
If you are
interested in this technical details, you can read the corresponding
question on stackoverflow. You may even reproduce the problem with the source code posted there.
There seems to be no
way to get the query running fast enough for the game, so I decided
to calculate the required data in the game server tier instead of the
sql server tier.
That is what I am
programming at the moment.
Next post will be
about the architecture of the server tier. I will probably even put a
sample project (C#) on the github account of Empires in Space.
No comments:
Post a Comment