Evil Trout Posted:
Forumwarz is a pretty complicated application as far as web apps go.
There are about 125 tables in the database. Now not all of them are used for storing character data, but there are at least 20-30 that do. Every time a character is reset we have to begin a transaction, lock those 25 tables and delete most of the rows, then update data to their initial levels.
In the meantime, those 20-30 tables are being hit by people playing the game, wanting to insert their gained cred or whatever, which causes the deadlocks. If we weren’t serving up multiple requests every second it might not be such an issue (in fact on the development server it’s never a problem), but it’s not a simple operation Log in to see images!
Ok, if people can send in updates for their ‘cred or whatever’ then can’t the players have a reset bumon that they can press to update everything in their character?