Age of Valor
login.php?sid=46f72834cf94b0b940150d27bafed1b5 profile.php?mode=register&sid=46f72834cf94b0b940150d27bafed1b5 faq.php?sid=46f72834cf94b0b940150d27bafed1b5 memberlist.php?sid=46f72834cf94b0b940150d27bafed1b5 search.php?sid=46f72834cf94b0b940150d27bafed1b5 index.php?sid=46f72834cf94b0b940150d27bafed1b5
Site Links: Home :: Donate :: Features :: Connection Guide




Age of Valor Forum Index » Patch Notes » Sept 11 2018 - SQL optimizations on TC1
Post new topic  Reply to topic View previous topic :: View next topic 
Sept 11 2018 - SQL optimizations on TC1
PostPosted: Wed Sep 12, 2018 4:10 am Reply with quote
Red Squirrel
AoV Owner
Joined: 13 Dec 2006
Posts: 8194
Location: Ontario, Canada




I have done some optimization on the SQL storage system on TC1, I encourage everyone to check and make sure all their items and such are as expected, as of today's backup date.

Looking for anything completely abnormal like say, a missing player backpack, or pets that are stabled and completely gone, missing accounts/characters etc. Before reporting do compare with live though. Keep in mind any changes done to live from this point on won't reflect TC1. So individual item losses can probably be dismissed as not being fully up to date with live or w/e but anything really bizarre then I'll look into.

I really do not expect there to be any issues but I will leave these changes running for a while just to make extra sure. At some point I will do some more stress testing in dev as well.

The changes involved optimizing how snapshots happen and it required a bit of table restructuring, but the actual saves and loads are more or less the same.
_________________

my blog

Honk if you love Jesus, text if you want to meet Him!
View user's profile Send private message Visit poster's website MSN Messenger
Sept 11 2018 - SQL optimizations on TC1
Age of Valor Forum Index » Patch Notes
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT  
Page 1 of 1  

  
  
 Post new topic  Reply to topic  
Shout Box


Powered by phpBB © 2001-2004 phpBB Group
Designed for Trushkin.net | Themes Database

This website and forum best viewed in a standards compliant browser such as Firefox or Opera.
Internet explorer is not recommended.