Age of Valor
login.php?sid=07ab3e617694a9e655d5be7d13b62d40 profile.php?mode=register&sid=07ab3e617694a9e655d5be7d13b62d40 faq.php?sid=07ab3e617694a9e655d5be7d13b62d40 memberlist.php?sid=07ab3e617694a9e655d5be7d13b62d40 search.php?sid=07ab3e617694a9e655d5be7d13b62d40 index.php?sid=07ab3e617694a9e655d5be7d13b62d40
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: 8283
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 | Themes Database

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