Sept 11 2018 - SQL optimizations on TC1

[Red Squirrel]

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.

Archived topic from AOV, old topic ID:6765, old post ID:39310