Age of Valor
login.php?sid=ca1253b0168c583a6ef7a12c2b06e46a profile.php?mode=register&sid=ca1253b0168c583a6ef7a12c2b06e46a faq.php?sid=ca1253b0168c583a6ef7a12c2b06e46a memberlist.php?sid=ca1253b0168c583a6ef7a12c2b06e46a search.php?sid=ca1253b0168c583a6ef7a12c2b06e46a index.php?sid=ca1253b0168c583a6ef7a12c2b06e46a
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: 8237
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.