Hi,
I have a situation where My Player can be in 2 rooms at same time..
1) UPDATEROOM - can Update PlayerObject
2) READONLYROOM - only for Read purpose()..
Lets assume Player Object in following pattern
PlayerObject - (40KB)
1) Sub-Object1(20KB) - FLD1 (10KB) & FLD2(10KB)
2) Sub-Object2(20KB) - FLD3 (10KB) & FLD4(10KB)
note: - assumption is that Objects size = sum of field sizes
Now, As far i understand if I update FLD1 is UPDATEROOM and save Entire playerObject only 10 Bytes of Data transfer will happen between server and BigDB - Correct me if i am wrong..
Now My question is that - If I "RefreshPlayerObject" in READONLYROOM after UPDATEROOM has made some changes (OR no changes at all), how many KB will be transferred between READONLYROOM and BIGDB... Will it be entire player Object object or Just the changes done..
This is imp from perspective that this will help me design my databases, I need to know based on my use how much data to keep in PlayerObject and how much to keep in different Tables..
Thanks,
Aseem