Site Speed Optimizations.
I noticed as the DB grew that the site was performing quite a bit worse and MySQL load getting fairly high on the server. I went ahead and looked through the mysql slow logs to find some of the queries that were slow and and were examining a huge number of rows (sometimes upwards of a million) and added several indexes to several columns in several tables.
From my testing it looks like this sped up the site significantly. Let me know if you guys noticed the improvement by commenting.
Click Here To Comment
Stepmania 5 Beta 1
Lots of work has been put into this release so please try it out. This is the best version of Stepmania yet!
StepMania 5.0 Beta 1a (Windows)
StepMania 5.0 Beta 1a (Mac OS X)
StepMania 5.0 Beta 1a (Linux 64 bit)
StepMania 5.0 Beta 1a (Linux 32 bit)
If you run into any issues please report them here.
Click Here To Comment
100k Songs played
The server has *just* passed 100k songs played. I honestly must say I did not expect it to happen this fast when I decided to revive stepmania online a few months ago nor did I think the site/server would have come so far when I decided to use OpenSMO as a back-end/base for the site.
Finally the server-side judgement has been completed and tested. The server now judges as if you were J4 regardless of what judgement level the client is set at. If you stay at J4 you should not notice much of a change. If you play at a high level of judgement there are some cases where toasties can be slightly harder to get and slightly less jump XP but it should only be a few notes difference if anything at all and only at very high judgement levels.
Because of the above change the grading is now done server-side as well. This means everyone gets standard grades which is based off the 3.95 default which is MAX based. This also means that since it is calculated on the fly (not sent by client) You will not immediately see a D grade when you get a combo breaker but instead will see what your grade would be if the song ends there. This means your grade can fluctuate down *and* up, IE go from AA -> A and then back to AA again.
Password Changes. I know a few people either chose bad passwords or messed up when creating their account so I have now added on the site the ability to change your password. Its listed near the logout button or you can do it here:
You can now view 'room' or 'game' pages so you can see who you played with on that game (like the old original SMO).
Near the star icon (where you could see your best results) there is a VS button whcih shows the 'game' results. Only entries since today will have room information otherwise it will list N/A for the room title, description, owner, etc...
Click Here to Comment
SMO IRC Room on Rizon