Forumwarz is the first "Massively Single-Player" online RPG completely built around Internet culture.

You are currently looking at Flamebate, our community forums. Players can discuss the game here, strategize, and role play as their characters.

You need to be logged in to post and to see the uncensored versions of these forums.

Log in or Learn about Forumwarz

Civil Discussion
Switch to Role-Playing Civil Discussion

Viewing a Post

Azsedcf

Avatar: Toy Mouth

Level 16 Troll

“Pain in the ASCII”

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?

Internet Delay Chat
Have fun playing!
To chat with other players, you must Join Forumwarz or Log In now!