City of Heroes: Live Forum Archive

Wentworth Backend Database Functionality

Hellwraith

By Hellwraith,
Posted on: 2009-11-19 10:01 in ALL ACCESS Gameplay Technical Issues Bugs

 

Posted

Hello all,

I have a somewhat detailed set of technical questions I am curious about, which may be propriatary and something that the developers don't want to comment on, but I am curious about how the database that drives Wentworth's has been implimented.

1. What do you use for the backend db? Oracle, db2, SQL Server, mySQL, etc?

2. Are you using full text searching to allow people to search the database?

3. What sort of schema do you use, and what optimizations? Is there partitioning, compression, etc?

4. Do you have a single DB for WW that crosses all servers, or is it one per server?

5. How much time do you spend in transaction vs. outside of the DB?

6. How many transactions do you perform per hour, etc?

Sorry, lots of questions, and I am assuming you may not be able to answer them, but I have noticed some spotty performance here and there, and was wondering if anyone had information that they could share.

Thanks for anything you can say to sate my curiosity!

Regards,
Hellwraith

P.S. If this isn't the proper venue, please feel free to send ma a PM regarding the questions. Thanks!

 

Posted

Your best bet in regards to this matter is to PM a developer directly, probably Ghost Falcon as he seems to be the lead tech/support guy. However, I wouldn't expect the devs to disclose backend information about how the servers run unless they see fit to do so.

@macskull, @Not Mac | XBL: macskull | Steam: macskull | Skype: macskull
"One day we all may see each other elsewhere. In Tyria, in Azeroth. We may pass each other and never know it. And that's sad. But if nothing else, we'll still have Rhode Island."

 

Posted

Quote:
Originally Posted by macskull View Post
Your best bet in regards to this matter is to PM a developer directly, probably Ghost Falcon as he seems to be the lead tech/support guy. However, I wouldn't expect the devs to disclose backend information about how the servers run unless they see fit to do so.
Cool, thanks for the idea... I couldn't remember which dev might be the one to ask, since I always think of Babs and Castle, but animations and powers probably wouldn't do much to help.

Hellwraith