I'm streaming C coding while I'm working on converting the entire character blob over to actual database tables.
I've been working on this over the past few weeks and am about 95% done, however if anyone is interested I have a stream up.
Some people have asked for it in the past so I just put it up while I'm working on stuff anyways.
www.twitch.tv/akkadius
Enjoy.
To give an idea why I am converting the character blob to database tables, 1) we've been wanting to do this forever for many reasons.
1) It will increase overall code performance more than 10 fold with all of the inefficient calls for saving and loading that we do in the database
2) We are saving a lot of blank data, for example EZ's database of characters is 2.6GB, after a mock convert I end up storing approximately 600MB in total in data broken out into individual tables.
3) The speed increase is phenominal as we are not saving everything every single time that a character has done a single little action.
- Whenever a character ups a skill point or spams it, everything is saved (skills/languages/aa/spells/character data/etc)
- Same thing goes for AA's, whenever a character loots or moves coins
- Everytime these save actions are spammed, the character_ table is locked, which leaves an opportunity for hangs to occur at any process because it is waiting for the character_ table to be opened. This is in the end, very inefficient.