View Single Post
  #18  
Old 03-26-2009, 12:26 AM
TuleenDonai TuleenDonai is offline
 
Join Date: Sep 2007
Location: Hayden, ID
Posts: 92
I've seen evidences of this as well. Many things are cached in volatile memory while the the server is running, and NOT actually written to the MySQL Database until a later time - sometimes, not at all.

This was a major reason why backpacks were funky for a long time.

Eventually, they will find all of these instances, and make sure DB updates happen in a more timely fashion. Only that can help prevent character corruption issues when a server either crashes or Deadlocks.

An analogy would be keeping all your computer based, in process, work in DRAM Memory, and only committing it to Hard Disk periodically (once an hour.) One Powerfail, BSOD, or app crash (Send Report?) and you lose all you work. Microsoft Word, Excel, Powerpoint, etc - prior to Autosave and Autobackups.

Who HASN'T this happened to? (It happened to my Pastor just last Saturday. Lost all his Sermon Notes. Had to start fresh!)

Last edited by TuleenDonai; 03-26-2009 at 12:32 AM.